package com.wocai.jrt.orgadmin.orders.model;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class OrdersBean {
    /**
     * order by 排序语句
     * 对应数据库表字段 orders
     */
    private String orderBy;

    /**
     * 分页开始记录
     * 对应数据库表字段 orders
     */
    private Integer start;

    /**
     * 分页大小
     * 对应数据库表字段 orders
     */
    private int pageSize = 10;

    /**
     * 是否指定 distinct 去除重复
     * 对应数据库表字段 orders
     */
    private boolean distinct;

    /**
     * 逻辑or语句
     * 对应数据库表字段 orders
     */
    private List<Criteria> oredCriteria;

    /**
     */
    public OrdersBean() {
        oredCriteria = new ArrayList<Criteria>();
    }

    /**
     * 设置 order by 排序语句
     */
    public void setOrderBy(String orderBy) {
        this.orderBy = orderBy;
    }

    /**
     * 获得 order by 排序语句
     */
    public String getOrderBy() {
        return orderBy;
    }

    /**
     * 设置 start，分页开始记录
     */
    public void setStart(Integer start) {
        this.start = start;
    }

    /**
     * 获得 start，分页开始记录
     */
    public Integer getStart() {
        return start;
    }

    /**
     * 设置 pageSize，分页大小
     */
    public void setPageSize(int pageSize) {
        this.pageSize = pageSize;
    }

    /**
     * 获得 pageSize，分页大小
     */
    public int getPageSize() {
        return pageSize;
    }

    /**
     * 设置是否指定 distinct 去除重复
     */
    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    /**
     * 是否设置了distinct语句，true是，false否。
     */
    public boolean isDistinct() {
        return distinct;
    }

    /**
     * 获得逻辑or语句
     */
    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    /**
     * 添加逻辑or语句
     */
    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    /**
     * 添加逻辑and语句
     */
    public void and(Criteria criteria) {
        criteria.setAndRelation(true);
        oredCriteria.add(criteria);
    }

    /**
     * 新建逻辑或or语句
     */
    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    /**
     * 新建逻辑and语句
     */
    public Criteria and() {
        Criteria criteria = createCriteriaInternal();
        criteria.setAndRelation(true);
        oredCriteria.add(criteria);
        return criteria;
    }

    /**
     * 创建查询条件，如果逻辑或为空，同时将查询条件放入。
     */
    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    /**
     * 创建新查询条件。
     */
    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    /**
     * 清除逻辑或or语句，并且distinct为false，不去重。
     */
    public void clear() {
        oredCriteria.clear();
    }

    /**
     * 该类对应数据库表 orders
     */
    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void orCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition, true));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void orCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value, true));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        protected void orCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2, true));
        }

        public Criteria andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(String value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(String value) {
            addCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(String value) {
            addCriterion("id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(String value) {
            addCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(String value) {
            addCriterion("id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(String value) {
            addCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria orIdIsNull() {
            orCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria orIdIsNotNull() {
            orCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria orIdEqualTo(String value) {
            orCriterion("id =", value, "id");
            return (Criteria) this;
        }

        public Criteria orIdNotEqualTo(String value) {
            orCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria orIdGreaterThan(String value) {
            orCriterion("id >", value, "id");
            return (Criteria) this;
        }

        public Criteria orIdGreaterThanOrEqualTo(String value) {
            orCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria orIdLessThan(String value) {
            orCriterion("id <", value, "id");
            return (Criteria) this;
        }

        public Criteria orIdLessThanOrEqualTo(String value) {
            orCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLike(String value) {
            addCriterion("id like", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotLike(String value) {
            addCriterion("id not like", value, "id");
            return (Criteria) this;
        }

        public Criteria orIdLike(String value) {
            orCriterion("id like", value, "id");
            return (Criteria) this;
        }

        public Criteria orIdNotLike(String value) {
            orCriterion("id not like", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<String> values) {
            addCriterion("id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<String> values) {
            addCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(String value1, String value2) {
            addCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(String value1, String value2) {
            addCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria orIdIn(List<String> values) {
            orCriterion("id in", values, "id");
            return (Criteria) this;
        }

        public Criteria orIdNotIn(List<String> values) {
            orCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria orIdBetween(String value1, String value2) {
            orCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria orIdNotBetween(String value1, String value2) {
            orCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andOrderIdIsNull() {
            addCriterion("order_id is null");
            return (Criteria) this;
        }

        public Criteria andOrderIdIsNotNull() {
            addCriterion("order_id is not null");
            return (Criteria) this;
        }

        public Criteria andOrderIdEqualTo(String value) {
            addCriterion("order_id =", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdNotEqualTo(String value) {
            addCriterion("order_id <>", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdGreaterThan(String value) {
            addCriterion("order_id >", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdGreaterThanOrEqualTo(String value) {
            addCriterion("order_id >=", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdLessThan(String value) {
            addCriterion("order_id <", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdLessThanOrEqualTo(String value) {
            addCriterion("order_id <=", value, "orderId");
            return (Criteria) this;
        }

        public Criteria orOrderIdIsNull() {
            orCriterion("order_id is null");
            return (Criteria) this;
        }

        public Criteria orOrderIdIsNotNull() {
            orCriterion("order_id is not null");
            return (Criteria) this;
        }

        public Criteria orOrderIdEqualTo(String value) {
            orCriterion("order_id =", value, "orderId");
            return (Criteria) this;
        }

        public Criteria orOrderIdNotEqualTo(String value) {
            orCriterion("order_id <>", value, "orderId");
            return (Criteria) this;
        }

        public Criteria orOrderIdGreaterThan(String value) {
            orCriterion("order_id >", value, "orderId");
            return (Criteria) this;
        }

        public Criteria orOrderIdGreaterThanOrEqualTo(String value) {
            orCriterion("order_id >=", value, "orderId");
            return (Criteria) this;
        }

        public Criteria orOrderIdLessThan(String value) {
            orCriterion("order_id <", value, "orderId");
            return (Criteria) this;
        }

        public Criteria orOrderIdLessThanOrEqualTo(String value) {
            orCriterion("order_id <=", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdLike(String value) {
            addCriterion("order_id like", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdNotLike(String value) {
            addCriterion("order_id not like", value, "orderId");
            return (Criteria) this;
        }

        public Criteria orOrderIdLike(String value) {
            orCriterion("order_id like", value, "orderId");
            return (Criteria) this;
        }

        public Criteria orOrderIdNotLike(String value) {
            orCriterion("order_id not like", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdIn(List<String> values) {
            addCriterion("order_id in", values, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdNotIn(List<String> values) {
            addCriterion("order_id not in", values, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdBetween(String value1, String value2) {
            addCriterion("order_id between", value1, value2, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdNotBetween(String value1, String value2) {
            addCriterion("order_id not between", value1, value2, "orderId");
            return (Criteria) this;
        }

        public Criteria orOrderIdIn(List<String> values) {
            orCriterion("order_id in", values, "orderId");
            return (Criteria) this;
        }

        public Criteria orOrderIdNotIn(List<String> values) {
            orCriterion("order_id not in", values, "orderId");
            return (Criteria) this;
        }

        public Criteria orOrderIdBetween(String value1, String value2) {
            orCriterion("order_id between", value1, value2, "orderId");
            return (Criteria) this;
        }

        public Criteria orOrderIdNotBetween(String value1, String value2) {
            orCriterion("order_id not between", value1, value2, "orderId");
            return (Criteria) this;
        }

        public Criteria andInvestorIdIsNull() {
            addCriterion("investor_id is null");
            return (Criteria) this;
        }

        public Criteria andInvestorIdIsNotNull() {
            addCriterion("investor_id is not null");
            return (Criteria) this;
        }

        public Criteria andInvestorIdEqualTo(String value) {
            addCriterion("investor_id =", value, "investorId");
            return (Criteria) this;
        }

        public Criteria andInvestorIdNotEqualTo(String value) {
            addCriterion("investor_id <>", value, "investorId");
            return (Criteria) this;
        }

        public Criteria andInvestorIdGreaterThan(String value) {
            addCriterion("investor_id >", value, "investorId");
            return (Criteria) this;
        }

        public Criteria andInvestorIdGreaterThanOrEqualTo(String value) {
            addCriterion("investor_id >=", value, "investorId");
            return (Criteria) this;
        }

        public Criteria andInvestorIdLessThan(String value) {
            addCriterion("investor_id <", value, "investorId");
            return (Criteria) this;
        }

        public Criteria andInvestorIdLessThanOrEqualTo(String value) {
            addCriterion("investor_id <=", value, "investorId");
            return (Criteria) this;
        }

        public Criteria orInvestorIdIsNull() {
            orCriterion("investor_id is null");
            return (Criteria) this;
        }

        public Criteria orInvestorIdIsNotNull() {
            orCriterion("investor_id is not null");
            return (Criteria) this;
        }

        public Criteria orInvestorIdEqualTo(String value) {
            orCriterion("investor_id =", value, "investorId");
            return (Criteria) this;
        }

        public Criteria orInvestorIdNotEqualTo(String value) {
            orCriterion("investor_id <>", value, "investorId");
            return (Criteria) this;
        }

        public Criteria orInvestorIdGreaterThan(String value) {
            orCriterion("investor_id >", value, "investorId");
            return (Criteria) this;
        }

        public Criteria orInvestorIdGreaterThanOrEqualTo(String value) {
            orCriterion("investor_id >=", value, "investorId");
            return (Criteria) this;
        }

        public Criteria orInvestorIdLessThan(String value) {
            orCriterion("investor_id <", value, "investorId");
            return (Criteria) this;
        }

        public Criteria orInvestorIdLessThanOrEqualTo(String value) {
            orCriterion("investor_id <=", value, "investorId");
            return (Criteria) this;
        }

        public Criteria andInvestorIdLike(String value) {
            addCriterion("investor_id like", value, "investorId");
            return (Criteria) this;
        }

        public Criteria andInvestorIdNotLike(String value) {
            addCriterion("investor_id not like", value, "investorId");
            return (Criteria) this;
        }

        public Criteria orInvestorIdLike(String value) {
            orCriterion("investor_id like", value, "investorId");
            return (Criteria) this;
        }

        public Criteria orInvestorIdNotLike(String value) {
            orCriterion("investor_id not like", value, "investorId");
            return (Criteria) this;
        }

        public Criteria andInvestorIdIn(List<String> values) {
            addCriterion("investor_id in", values, "investorId");
            return (Criteria) this;
        }

        public Criteria andInvestorIdNotIn(List<String> values) {
            addCriterion("investor_id not in", values, "investorId");
            return (Criteria) this;
        }

        public Criteria andInvestorIdBetween(String value1, String value2) {
            addCriterion("investor_id between", value1, value2, "investorId");
            return (Criteria) this;
        }

        public Criteria andInvestorIdNotBetween(String value1, String value2) {
            addCriterion("investor_id not between", value1, value2, "investorId");
            return (Criteria) this;
        }

        public Criteria orInvestorIdIn(List<String> values) {
            orCriterion("investor_id in", values, "investorId");
            return (Criteria) this;
        }

        public Criteria orInvestorIdNotIn(List<String> values) {
            orCriterion("investor_id not in", values, "investorId");
            return (Criteria) this;
        }

        public Criteria orInvestorIdBetween(String value1, String value2) {
            orCriterion("investor_id between", value1, value2, "investorId");
            return (Criteria) this;
        }

        public Criteria orInvestorIdNotBetween(String value1, String value2) {
            orCriterion("investor_id not between", value1, value2, "investorId");
            return (Criteria) this;
        }

        public Criteria andProductIdIsNull() {
            addCriterion("product_id is null");
            return (Criteria) this;
        }

        public Criteria andProductIdIsNotNull() {
            addCriterion("product_id is not null");
            return (Criteria) this;
        }

        public Criteria andProductIdEqualTo(String value) {
            addCriterion("product_id =", value, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdNotEqualTo(String value) {
            addCriterion("product_id <>", value, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdGreaterThan(String value) {
            addCriterion("product_id >", value, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdGreaterThanOrEqualTo(String value) {
            addCriterion("product_id >=", value, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdLessThan(String value) {
            addCriterion("product_id <", value, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdLessThanOrEqualTo(String value) {
            addCriterion("product_id <=", value, "productId");
            return (Criteria) this;
        }

        public Criteria orProductIdIsNull() {
            orCriterion("product_id is null");
            return (Criteria) this;
        }

        public Criteria orProductIdIsNotNull() {
            orCriterion("product_id is not null");
            return (Criteria) this;
        }

        public Criteria orProductIdEqualTo(String value) {
            orCriterion("product_id =", value, "productId");
            return (Criteria) this;
        }

        public Criteria orProductIdNotEqualTo(String value) {
            orCriterion("product_id <>", value, "productId");
            return (Criteria) this;
        }

        public Criteria orProductIdGreaterThan(String value) {
            orCriterion("product_id >", value, "productId");
            return (Criteria) this;
        }

        public Criteria orProductIdGreaterThanOrEqualTo(String value) {
            orCriterion("product_id >=", value, "productId");
            return (Criteria) this;
        }

        public Criteria orProductIdLessThan(String value) {
            orCriterion("product_id <", value, "productId");
            return (Criteria) this;
        }

        public Criteria orProductIdLessThanOrEqualTo(String value) {
            orCriterion("product_id <=", value, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdLike(String value) {
            addCriterion("product_id like", value, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdNotLike(String value) {
            addCriterion("product_id not like", value, "productId");
            return (Criteria) this;
        }

        public Criteria orProductIdLike(String value) {
            orCriterion("product_id like", value, "productId");
            return (Criteria) this;
        }

        public Criteria orProductIdNotLike(String value) {
            orCriterion("product_id not like", value, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdIn(List<String> values) {
            addCriterion("product_id in", values, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdNotIn(List<String> values) {
            addCriterion("product_id not in", values, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdBetween(String value1, String value2) {
            addCriterion("product_id between", value1, value2, "productId");
            return (Criteria) this;
        }

        public Criteria andProductIdNotBetween(String value1, String value2) {
            addCriterion("product_id not between", value1, value2, "productId");
            return (Criteria) this;
        }

        public Criteria orProductIdIn(List<String> values) {
            orCriterion("product_id in", values, "productId");
            return (Criteria) this;
        }

        public Criteria orProductIdNotIn(List<String> values) {
            orCriterion("product_id not in", values, "productId");
            return (Criteria) this;
        }

        public Criteria orProductIdBetween(String value1, String value2) {
            orCriterion("product_id between", value1, value2, "productId");
            return (Criteria) this;
        }

        public Criteria orProductIdNotBetween(String value1, String value2) {
            orCriterion("product_id not between", value1, value2, "productId");
            return (Criteria) this;
        }

        public Criteria andProductNameIsNull() {
            addCriterion("product_name is null");
            return (Criteria) this;
        }

        public Criteria andProductNameIsNotNull() {
            addCriterion("product_name is not null");
            return (Criteria) this;
        }

        public Criteria andProductNameEqualTo(String value) {
            addCriterion("product_name =", value, "productName");
            return (Criteria) this;
        }

        public Criteria andProductNameNotEqualTo(String value) {
            addCriterion("product_name <>", value, "productName");
            return (Criteria) this;
        }

        public Criteria andProductNameGreaterThan(String value) {
            addCriterion("product_name >", value, "productName");
            return (Criteria) this;
        }

        public Criteria andProductNameGreaterThanOrEqualTo(String value) {
            addCriterion("product_name >=", value, "productName");
            return (Criteria) this;
        }

        public Criteria andProductNameLessThan(String value) {
            addCriterion("product_name <", value, "productName");
            return (Criteria) this;
        }

        public Criteria andProductNameLessThanOrEqualTo(String value) {
            addCriterion("product_name <=", value, "productName");
            return (Criteria) this;
        }

        public Criteria orProductNameIsNull() {
            orCriterion("product_name is null");
            return (Criteria) this;
        }

        public Criteria orProductNameIsNotNull() {
            orCriterion("product_name is not null");
            return (Criteria) this;
        }

        public Criteria orProductNameEqualTo(String value) {
            orCriterion("product_name =", value, "productName");
            return (Criteria) this;
        }

        public Criteria orProductNameNotEqualTo(String value) {
            orCriterion("product_name <>", value, "productName");
            return (Criteria) this;
        }

        public Criteria orProductNameGreaterThan(String value) {
            orCriterion("product_name >", value, "productName");
            return (Criteria) this;
        }

        public Criteria orProductNameGreaterThanOrEqualTo(String value) {
            orCriterion("product_name >=", value, "productName");
            return (Criteria) this;
        }

        public Criteria orProductNameLessThan(String value) {
            orCriterion("product_name <", value, "productName");
            return (Criteria) this;
        }

        public Criteria orProductNameLessThanOrEqualTo(String value) {
            orCriterion("product_name <=", value, "productName");
            return (Criteria) this;
        }

        public Criteria andProductNameLike(String value) {
            addCriterion("product_name like", value, "productName");
            return (Criteria) this;
        }

        public Criteria andProductNameNotLike(String value) {
            addCriterion("product_name not like", value, "productName");
            return (Criteria) this;
        }

        public Criteria orProductNameLike(String value) {
            orCriterion("product_name like", value, "productName");
            return (Criteria) this;
        }

        public Criteria orProductNameNotLike(String value) {
            orCriterion("product_name not like", value, "productName");
            return (Criteria) this;
        }

        public Criteria andProductNameIn(List<String> values) {
            addCriterion("product_name in", values, "productName");
            return (Criteria) this;
        }

        public Criteria andProductNameNotIn(List<String> values) {
            addCriterion("product_name not in", values, "productName");
            return (Criteria) this;
        }

        public Criteria andProductNameBetween(String value1, String value2) {
            addCriterion("product_name between", value1, value2, "productName");
            return (Criteria) this;
        }

        public Criteria andProductNameNotBetween(String value1, String value2) {
            addCriterion("product_name not between", value1, value2, "productName");
            return (Criteria) this;
        }

        public Criteria orProductNameIn(List<String> values) {
            orCriterion("product_name in", values, "productName");
            return (Criteria) this;
        }

        public Criteria orProductNameNotIn(List<String> values) {
            orCriterion("product_name not in", values, "productName");
            return (Criteria) this;
        }

        public Criteria orProductNameBetween(String value1, String value2) {
            orCriterion("product_name between", value1, value2, "productName");
            return (Criteria) this;
        }

        public Criteria orProductNameNotBetween(String value1, String value2) {
            orCriterion("product_name not between", value1, value2, "productName");
            return (Criteria) this;
        }

        public Criteria andProductBriefNameIsNull() {
            addCriterion("product_brief_name is null");
            return (Criteria) this;
        }

        public Criteria andProductBriefNameIsNotNull() {
            addCriterion("product_brief_name is not null");
            return (Criteria) this;
        }

        public Criteria andProductBriefNameEqualTo(String value) {
            addCriterion("product_brief_name =", value, "productBriefName");
            return (Criteria) this;
        }

        public Criteria andProductBriefNameNotEqualTo(String value) {
            addCriterion("product_brief_name <>", value, "productBriefName");
            return (Criteria) this;
        }

        public Criteria andProductBriefNameGreaterThan(String value) {
            addCriterion("product_brief_name >", value, "productBriefName");
            return (Criteria) this;
        }

        public Criteria andProductBriefNameGreaterThanOrEqualTo(String value) {
            addCriterion("product_brief_name >=", value, "productBriefName");
            return (Criteria) this;
        }

        public Criteria andProductBriefNameLessThan(String value) {
            addCriterion("product_brief_name <", value, "productBriefName");
            return (Criteria) this;
        }

        public Criteria andProductBriefNameLessThanOrEqualTo(String value) {
            addCriterion("product_brief_name <=", value, "productBriefName");
            return (Criteria) this;
        }

        public Criteria orProductBriefNameIsNull() {
            orCriterion("product_brief_name is null");
            return (Criteria) this;
        }

        public Criteria orProductBriefNameIsNotNull() {
            orCriterion("product_brief_name is not null");
            return (Criteria) this;
        }

        public Criteria orProductBriefNameEqualTo(String value) {
            orCriterion("product_brief_name =", value, "productBriefName");
            return (Criteria) this;
        }

        public Criteria orProductBriefNameNotEqualTo(String value) {
            orCriterion("product_brief_name <>", value, "productBriefName");
            return (Criteria) this;
        }

        public Criteria orProductBriefNameGreaterThan(String value) {
            orCriterion("product_brief_name >", value, "productBriefName");
            return (Criteria) this;
        }

        public Criteria orProductBriefNameGreaterThanOrEqualTo(String value) {
            orCriterion("product_brief_name >=", value, "productBriefName");
            return (Criteria) this;
        }

        public Criteria orProductBriefNameLessThan(String value) {
            orCriterion("product_brief_name <", value, "productBriefName");
            return (Criteria) this;
        }

        public Criteria orProductBriefNameLessThanOrEqualTo(String value) {
            orCriterion("product_brief_name <=", value, "productBriefName");
            return (Criteria) this;
        }

        public Criteria andProductBriefNameLike(String value) {
            addCriterion("product_brief_name like", value, "productBriefName");
            return (Criteria) this;
        }

        public Criteria andProductBriefNameNotLike(String value) {
            addCriterion("product_brief_name not like", value, "productBriefName");
            return (Criteria) this;
        }

        public Criteria orProductBriefNameLike(String value) {
            orCriterion("product_brief_name like", value, "productBriefName");
            return (Criteria) this;
        }

        public Criteria orProductBriefNameNotLike(String value) {
            orCriterion("product_brief_name not like", value, "productBriefName");
            return (Criteria) this;
        }

        public Criteria andProductBriefNameIn(List<String> values) {
            addCriterion("product_brief_name in", values, "productBriefName");
            return (Criteria) this;
        }

        public Criteria andProductBriefNameNotIn(List<String> values) {
            addCriterion("product_brief_name not in", values, "productBriefName");
            return (Criteria) this;
        }

        public Criteria andProductBriefNameBetween(String value1, String value2) {
            addCriterion("product_brief_name between", value1, value2, "productBriefName");
            return (Criteria) this;
        }

        public Criteria andProductBriefNameNotBetween(String value1, String value2) {
            addCriterion("product_brief_name not between", value1, value2, "productBriefName");
            return (Criteria) this;
        }

        public Criteria orProductBriefNameIn(List<String> values) {
            orCriterion("product_brief_name in", values, "productBriefName");
            return (Criteria) this;
        }

        public Criteria orProductBriefNameNotIn(List<String> values) {
            orCriterion("product_brief_name not in", values, "productBriefName");
            return (Criteria) this;
        }

        public Criteria orProductBriefNameBetween(String value1, String value2) {
            orCriterion("product_brief_name between", value1, value2, "productBriefName");
            return (Criteria) this;
        }

        public Criteria orProductBriefNameNotBetween(String value1, String value2) {
            orCriterion("product_brief_name not between", value1, value2, "productBriefName");
            return (Criteria) this;
        }

        public Criteria andOrderAmountIsNull() {
            addCriterion("order_amount is null");
            return (Criteria) this;
        }

        public Criteria andOrderAmountIsNotNull() {
            addCriterion("order_amount is not null");
            return (Criteria) this;
        }

        public Criteria andOrderAmountEqualTo(BigDecimal value) {
            addCriterion("order_amount =", value, "orderAmount");
            return (Criteria) this;
        }

        public Criteria andOrderAmountNotEqualTo(BigDecimal value) {
            addCriterion("order_amount <>", value, "orderAmount");
            return (Criteria) this;
        }

        public Criteria andOrderAmountGreaterThan(BigDecimal value) {
            addCriterion("order_amount >", value, "orderAmount");
            return (Criteria) this;
        }

        public Criteria andOrderAmountGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("order_amount >=", value, "orderAmount");
            return (Criteria) this;
        }

        public Criteria andOrderAmountLessThan(BigDecimal value) {
            addCriterion("order_amount <", value, "orderAmount");
            return (Criteria) this;
        }

        public Criteria andOrderAmountLessThanOrEqualTo(BigDecimal value) {
            addCriterion("order_amount <=", value, "orderAmount");
            return (Criteria) this;
        }

        public Criteria orOrderAmountIsNull() {
            orCriterion("order_amount is null");
            return (Criteria) this;
        }

        public Criteria orOrderAmountIsNotNull() {
            orCriterion("order_amount is not null");
            return (Criteria) this;
        }

        public Criteria orOrderAmountEqualTo(BigDecimal value) {
            orCriterion("order_amount =", value, "orderAmount");
            return (Criteria) this;
        }

        public Criteria orOrderAmountNotEqualTo(BigDecimal value) {
            orCriterion("order_amount <>", value, "orderAmount");
            return (Criteria) this;
        }

        public Criteria orOrderAmountGreaterThan(BigDecimal value) {
            orCriterion("order_amount >", value, "orderAmount");
            return (Criteria) this;
        }

        public Criteria orOrderAmountGreaterThanOrEqualTo(BigDecimal value) {
            orCriterion("order_amount >=", value, "orderAmount");
            return (Criteria) this;
        }

        public Criteria orOrderAmountLessThan(BigDecimal value) {
            orCriterion("order_amount <", value, "orderAmount");
            return (Criteria) this;
        }

        public Criteria orOrderAmountLessThanOrEqualTo(BigDecimal value) {
            orCriterion("order_amount <=", value, "orderAmount");
            return (Criteria) this;
        }

        public Criteria andOrderAmountIn(List<BigDecimal> values) {
            addCriterion("order_amount in", values, "orderAmount");
            return (Criteria) this;
        }

        public Criteria andOrderAmountNotIn(List<BigDecimal> values) {
            addCriterion("order_amount not in", values, "orderAmount");
            return (Criteria) this;
        }

        public Criteria andOrderAmountBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("order_amount between", value1, value2, "orderAmount");
            return (Criteria) this;
        }

        public Criteria andOrderAmountNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("order_amount not between", value1, value2, "orderAmount");
            return (Criteria) this;
        }

        public Criteria orOrderAmountIn(List<BigDecimal> values) {
            orCriterion("order_amount in", values, "orderAmount");
            return (Criteria) this;
        }

        public Criteria orOrderAmountNotIn(List<BigDecimal> values) {
            orCriterion("order_amount not in", values, "orderAmount");
            return (Criteria) this;
        }

        public Criteria orOrderAmountBetween(BigDecimal value1, BigDecimal value2) {
            orCriterion("order_amount between", value1, value2, "orderAmount");
            return (Criteria) this;
        }

        public Criteria orOrderAmountNotBetween(BigDecimal value1, BigDecimal value2) {
            orCriterion("order_amount not between", value1, value2, "orderAmount");
            return (Criteria) this;
        }

        public Criteria andEmployeeIdIsNull() {
            addCriterion("employee_id is null");
            return (Criteria) this;
        }

        public Criteria andEmployeeIdIsNotNull() {
            addCriterion("employee_id is not null");
            return (Criteria) this;
        }

        public Criteria andEmployeeIdEqualTo(String value) {
            addCriterion("employee_id =", value, "employeeId");
            return (Criteria) this;
        }

        public Criteria andEmployeeIdNotEqualTo(String value) {
            addCriterion("employee_id <>", value, "employeeId");
            return (Criteria) this;
        }

        public Criteria andEmployeeIdGreaterThan(String value) {
            addCriterion("employee_id >", value, "employeeId");
            return (Criteria) this;
        }

        public Criteria andEmployeeIdGreaterThanOrEqualTo(String value) {
            addCriterion("employee_id >=", value, "employeeId");
            return (Criteria) this;
        }

        public Criteria andEmployeeIdLessThan(String value) {
            addCriterion("employee_id <", value, "employeeId");
            return (Criteria) this;
        }

        public Criteria andEmployeeIdLessThanOrEqualTo(String value) {
            addCriterion("employee_id <=", value, "employeeId");
            return (Criteria) this;
        }

        public Criteria orEmployeeIdIsNull() {
            orCriterion("employee_id is null");
            return (Criteria) this;
        }

        public Criteria orEmployeeIdIsNotNull() {
            orCriterion("employee_id is not null");
            return (Criteria) this;
        }

        public Criteria orEmployeeIdEqualTo(String value) {
            orCriterion("employee_id =", value, "employeeId");
            return (Criteria) this;
        }

        public Criteria orEmployeeIdNotEqualTo(String value) {
            orCriterion("employee_id <>", value, "employeeId");
            return (Criteria) this;
        }

        public Criteria orEmployeeIdGreaterThan(String value) {
            orCriterion("employee_id >", value, "employeeId");
            return (Criteria) this;
        }

        public Criteria orEmployeeIdGreaterThanOrEqualTo(String value) {
            orCriterion("employee_id >=", value, "employeeId");
            return (Criteria) this;
        }

        public Criteria orEmployeeIdLessThan(String value) {
            orCriterion("employee_id <", value, "employeeId");
            return (Criteria) this;
        }

        public Criteria orEmployeeIdLessThanOrEqualTo(String value) {
            orCriterion("employee_id <=", value, "employeeId");
            return (Criteria) this;
        }

        public Criteria andEmployeeIdLike(String value) {
            addCriterion("employee_id like", value, "employeeId");
            return (Criteria) this;
        }

        public Criteria andEmployeeIdNotLike(String value) {
            addCriterion("employee_id not like", value, "employeeId");
            return (Criteria) this;
        }

        public Criteria orEmployeeIdLike(String value) {
            orCriterion("employee_id like", value, "employeeId");
            return (Criteria) this;
        }

        public Criteria orEmployeeIdNotLike(String value) {
            orCriterion("employee_id not like", value, "employeeId");
            return (Criteria) this;
        }

        public Criteria andEmployeeIdIn(List<String> values) {
            addCriterion("employee_id in", values, "employeeId");
            return (Criteria) this;
        }

        public Criteria andEmployeeIdNotIn(List<String> values) {
            addCriterion("employee_id not in", values, "employeeId");
            return (Criteria) this;
        }

        public Criteria andEmployeeIdBetween(String value1, String value2) {
            addCriterion("employee_id between", value1, value2, "employeeId");
            return (Criteria) this;
        }

        public Criteria andEmployeeIdNotBetween(String value1, String value2) {
            addCriterion("employee_id not between", value1, value2, "employeeId");
            return (Criteria) this;
        }

        public Criteria orEmployeeIdIn(List<String> values) {
            orCriterion("employee_id in", values, "employeeId");
            return (Criteria) this;
        }

        public Criteria orEmployeeIdNotIn(List<String> values) {
            orCriterion("employee_id not in", values, "employeeId");
            return (Criteria) this;
        }

        public Criteria orEmployeeIdBetween(String value1, String value2) {
            orCriterion("employee_id between", value1, value2, "employeeId");
            return (Criteria) this;
        }

        public Criteria orEmployeeIdNotBetween(String value1, String value2) {
            orCriterion("employee_id not between", value1, value2, "employeeId");
            return (Criteria) this;
        }

        public Criteria andEmployeeNameIsNull() {
            addCriterion("employee_name is null");
            return (Criteria) this;
        }

        public Criteria andEmployeeNameIsNotNull() {
            addCriterion("employee_name is not null");
            return (Criteria) this;
        }

        public Criteria andEmployeeNameEqualTo(String value) {
            addCriterion("employee_name =", value, "employeeName");
            return (Criteria) this;
        }

        public Criteria andEmployeeNameNotEqualTo(String value) {
            addCriterion("employee_name <>", value, "employeeName");
            return (Criteria) this;
        }

        public Criteria andEmployeeNameGreaterThan(String value) {
            addCriterion("employee_name >", value, "employeeName");
            return (Criteria) this;
        }

        public Criteria andEmployeeNameGreaterThanOrEqualTo(String value) {
            addCriterion("employee_name >=", value, "employeeName");
            return (Criteria) this;
        }

        public Criteria andEmployeeNameLessThan(String value) {
            addCriterion("employee_name <", value, "employeeName");
            return (Criteria) this;
        }

        public Criteria andEmployeeNameLessThanOrEqualTo(String value) {
            addCriterion("employee_name <=", value, "employeeName");
            return (Criteria) this;
        }

        public Criteria orEmployeeNameIsNull() {
            orCriterion("employee_name is null");
            return (Criteria) this;
        }

        public Criteria orEmployeeNameIsNotNull() {
            orCriterion("employee_name is not null");
            return (Criteria) this;
        }

        public Criteria orEmployeeNameEqualTo(String value) {
            orCriterion("employee_name =", value, "employeeName");
            return (Criteria) this;
        }

        public Criteria orEmployeeNameNotEqualTo(String value) {
            orCriterion("employee_name <>", value, "employeeName");
            return (Criteria) this;
        }

        public Criteria orEmployeeNameGreaterThan(String value) {
            orCriterion("employee_name >", value, "employeeName");
            return (Criteria) this;
        }

        public Criteria orEmployeeNameGreaterThanOrEqualTo(String value) {
            orCriterion("employee_name >=", value, "employeeName");
            return (Criteria) this;
        }

        public Criteria orEmployeeNameLessThan(String value) {
            orCriterion("employee_name <", value, "employeeName");
            return (Criteria) this;
        }

        public Criteria orEmployeeNameLessThanOrEqualTo(String value) {
            orCriterion("employee_name <=", value, "employeeName");
            return (Criteria) this;
        }

        public Criteria andEmployeeNameLike(String value) {
            addCriterion("employee_name like", value, "employeeName");
            return (Criteria) this;
        }

        public Criteria andEmployeeNameNotLike(String value) {
            addCriterion("employee_name not like", value, "employeeName");
            return (Criteria) this;
        }

        public Criteria orEmployeeNameLike(String value) {
            orCriterion("employee_name like", value, "employeeName");
            return (Criteria) this;
        }

        public Criteria orEmployeeNameNotLike(String value) {
            orCriterion("employee_name not like", value, "employeeName");
            return (Criteria) this;
        }

        public Criteria andEmployeeNameIn(List<String> values) {
            addCriterion("employee_name in", values, "employeeName");
            return (Criteria) this;
        }

        public Criteria andEmployeeNameNotIn(List<String> values) {
            addCriterion("employee_name not in", values, "employeeName");
            return (Criteria) this;
        }

        public Criteria andEmployeeNameBetween(String value1, String value2) {
            addCriterion("employee_name between", value1, value2, "employeeName");
            return (Criteria) this;
        }

        public Criteria andEmployeeNameNotBetween(String value1, String value2) {
            addCriterion("employee_name not between", value1, value2, "employeeName");
            return (Criteria) this;
        }

        public Criteria orEmployeeNameIn(List<String> values) {
            orCriterion("employee_name in", values, "employeeName");
            return (Criteria) this;
        }

        public Criteria orEmployeeNameNotIn(List<String> values) {
            orCriterion("employee_name not in", values, "employeeName");
            return (Criteria) this;
        }

        public Criteria orEmployeeNameBetween(String value1, String value2) {
            orCriterion("employee_name between", value1, value2, "employeeName");
            return (Criteria) this;
        }

        public Criteria orEmployeeNameNotBetween(String value1, String value2) {
            orCriterion("employee_name not between", value1, value2, "employeeName");
            return (Criteria) this;
        }

        public Criteria andOrderTimeIsNull() {
            addCriterion("order_time is null");
            return (Criteria) this;
        }

        public Criteria andOrderTimeIsNotNull() {
            addCriterion("order_time is not null");
            return (Criteria) this;
        }

        public Criteria andOrderTimeEqualTo(Date value) {
            addCriterion("order_time =", value, "orderTime");
            return (Criteria) this;
        }

        public Criteria andOrderTimeNotEqualTo(Date value) {
            addCriterion("order_time <>", value, "orderTime");
            return (Criteria) this;
        }

        public Criteria andOrderTimeGreaterThan(Date value) {
            addCriterion("order_time >", value, "orderTime");
            return (Criteria) this;
        }

        public Criteria andOrderTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("order_time >=", value, "orderTime");
            return (Criteria) this;
        }

        public Criteria andOrderTimeLessThan(Date value) {
            addCriterion("order_time <", value, "orderTime");
            return (Criteria) this;
        }

        public Criteria andOrderTimeLessThanOrEqualTo(Date value) {
            addCriterion("order_time <=", value, "orderTime");
            return (Criteria) this;
        }

        public Criteria orOrderTimeIsNull() {
            orCriterion("order_time is null");
            return (Criteria) this;
        }

        public Criteria orOrderTimeIsNotNull() {
            orCriterion("order_time is not null");
            return (Criteria) this;
        }

        public Criteria orOrderTimeEqualTo(Date value) {
            orCriterion("order_time =", value, "orderTime");
            return (Criteria) this;
        }

        public Criteria orOrderTimeNotEqualTo(Date value) {
            orCriterion("order_time <>", value, "orderTime");
            return (Criteria) this;
        }

        public Criteria orOrderTimeGreaterThan(Date value) {
            orCriterion("order_time >", value, "orderTime");
            return (Criteria) this;
        }

        public Criteria orOrderTimeGreaterThanOrEqualTo(Date value) {
            orCriterion("order_time >=", value, "orderTime");
            return (Criteria) this;
        }

        public Criteria orOrderTimeLessThan(Date value) {
            orCriterion("order_time <", value, "orderTime");
            return (Criteria) this;
        }

        public Criteria orOrderTimeLessThanOrEqualTo(Date value) {
            orCriterion("order_time <=", value, "orderTime");
            return (Criteria) this;
        }

        public Criteria andOrderTimeIn(List<Date> values) {
            addCriterion("order_time in", values, "orderTime");
            return (Criteria) this;
        }

        public Criteria andOrderTimeNotIn(List<Date> values) {
            addCriterion("order_time not in", values, "orderTime");
            return (Criteria) this;
        }

        public Criteria andOrderTimeBetween(Date value1, Date value2) {
            addCriterion("order_time between", value1, value2, "orderTime");
            return (Criteria) this;
        }

        public Criteria andOrderTimeNotBetween(Date value1, Date value2) {
            addCriterion("order_time not between", value1, value2, "orderTime");
            return (Criteria) this;
        }

        public Criteria orOrderTimeIn(List<Date> values) {
            orCriterion("order_time in", values, "orderTime");
            return (Criteria) this;
        }

        public Criteria orOrderTimeNotIn(List<Date> values) {
            orCriterion("order_time not in", values, "orderTime");
            return (Criteria) this;
        }

        public Criteria orOrderTimeBetween(Date value1, Date value2) {
            orCriterion("order_time between", value1, value2, "orderTime");
            return (Criteria) this;
        }

        public Criteria orOrderTimeNotBetween(Date value1, Date value2) {
            orCriterion("order_time not between", value1, value2, "orderTime");
            return (Criteria) this;
        }

        public Criteria andPayTimeIsNull() {
            addCriterion("pay_time is null");
            return (Criteria) this;
        }

        public Criteria andPayTimeIsNotNull() {
            addCriterion("pay_time is not null");
            return (Criteria) this;
        }

        public Criteria andPayTimeEqualTo(Date value) {
            addCriterion("pay_time =", value, "payTime");
            return (Criteria) this;
        }

        public Criteria andPayTimeNotEqualTo(Date value) {
            addCriterion("pay_time <>", value, "payTime");
            return (Criteria) this;
        }

        public Criteria andPayTimeGreaterThan(Date value) {
            addCriterion("pay_time >", value, "payTime");
            return (Criteria) this;
        }

        public Criteria andPayTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("pay_time >=", value, "payTime");
            return (Criteria) this;
        }

        public Criteria andPayTimeLessThan(Date value) {
            addCriterion("pay_time <", value, "payTime");
            return (Criteria) this;
        }

        public Criteria andPayTimeLessThanOrEqualTo(Date value) {
            addCriterion("pay_time <=", value, "payTime");
            return (Criteria) this;
        }

        public Criteria orPayTimeIsNull() {
            orCriterion("pay_time is null");
            return (Criteria) this;
        }

        public Criteria orPayTimeIsNotNull() {
            orCriterion("pay_time is not null");
            return (Criteria) this;
        }

        public Criteria orPayTimeEqualTo(Date value) {
            orCriterion("pay_time =", value, "payTime");
            return (Criteria) this;
        }

        public Criteria orPayTimeNotEqualTo(Date value) {
            orCriterion("pay_time <>", value, "payTime");
            return (Criteria) this;
        }

        public Criteria orPayTimeGreaterThan(Date value) {
            orCriterion("pay_time >", value, "payTime");
            return (Criteria) this;
        }

        public Criteria orPayTimeGreaterThanOrEqualTo(Date value) {
            orCriterion("pay_time >=", value, "payTime");
            return (Criteria) this;
        }

        public Criteria orPayTimeLessThan(Date value) {
            orCriterion("pay_time <", value, "payTime");
            return (Criteria) this;
        }

        public Criteria orPayTimeLessThanOrEqualTo(Date value) {
            orCriterion("pay_time <=", value, "payTime");
            return (Criteria) this;
        }

        public Criteria andPayTimeIn(List<Date> values) {
            addCriterion("pay_time in", values, "payTime");
            return (Criteria) this;
        }

        public Criteria andPayTimeNotIn(List<Date> values) {
            addCriterion("pay_time not in", values, "payTime");
            return (Criteria) this;
        }

        public Criteria andPayTimeBetween(Date value1, Date value2) {
            addCriterion("pay_time between", value1, value2, "payTime");
            return (Criteria) this;
        }

        public Criteria andPayTimeNotBetween(Date value1, Date value2) {
            addCriterion("pay_time not between", value1, value2, "payTime");
            return (Criteria) this;
        }

        public Criteria orPayTimeIn(List<Date> values) {
            orCriterion("pay_time in", values, "payTime");
            return (Criteria) this;
        }

        public Criteria orPayTimeNotIn(List<Date> values) {
            orCriterion("pay_time not in", values, "payTime");
            return (Criteria) this;
        }

        public Criteria orPayTimeBetween(Date value1, Date value2) {
            orCriterion("pay_time between", value1, value2, "payTime");
            return (Criteria) this;
        }

        public Criteria orPayTimeNotBetween(Date value1, Date value2) {
            orCriterion("pay_time not between", value1, value2, "payTime");
            return (Criteria) this;
        }

        public Criteria andPadIdIsNull() {
            addCriterion("pad_id is null");
            return (Criteria) this;
        }

        public Criteria andPadIdIsNotNull() {
            addCriterion("pad_id is not null");
            return (Criteria) this;
        }

        public Criteria andPadIdEqualTo(String value) {
            addCriterion("pad_id =", value, "padId");
            return (Criteria) this;
        }

        public Criteria andPadIdNotEqualTo(String value) {
            addCriterion("pad_id <>", value, "padId");
            return (Criteria) this;
        }

        public Criteria andPadIdGreaterThan(String value) {
            addCriterion("pad_id >", value, "padId");
            return (Criteria) this;
        }

        public Criteria andPadIdGreaterThanOrEqualTo(String value) {
            addCriterion("pad_id >=", value, "padId");
            return (Criteria) this;
        }

        public Criteria andPadIdLessThan(String value) {
            addCriterion("pad_id <", value, "padId");
            return (Criteria) this;
        }

        public Criteria andPadIdLessThanOrEqualTo(String value) {
            addCriterion("pad_id <=", value, "padId");
            return (Criteria) this;
        }

        public Criteria orPadIdIsNull() {
            orCriterion("pad_id is null");
            return (Criteria) this;
        }

        public Criteria orPadIdIsNotNull() {
            orCriterion("pad_id is not null");
            return (Criteria) this;
        }

        public Criteria orPadIdEqualTo(String value) {
            orCriterion("pad_id =", value, "padId");
            return (Criteria) this;
        }

        public Criteria orPadIdNotEqualTo(String value) {
            orCriterion("pad_id <>", value, "padId");
            return (Criteria) this;
        }

        public Criteria orPadIdGreaterThan(String value) {
            orCriterion("pad_id >", value, "padId");
            return (Criteria) this;
        }

        public Criteria orPadIdGreaterThanOrEqualTo(String value) {
            orCriterion("pad_id >=", value, "padId");
            return (Criteria) this;
        }

        public Criteria orPadIdLessThan(String value) {
            orCriterion("pad_id <", value, "padId");
            return (Criteria) this;
        }

        public Criteria orPadIdLessThanOrEqualTo(String value) {
            orCriterion("pad_id <=", value, "padId");
            return (Criteria) this;
        }

        public Criteria andPadIdLike(String value) {
            addCriterion("pad_id like", value, "padId");
            return (Criteria) this;
        }

        public Criteria andPadIdNotLike(String value) {
            addCriterion("pad_id not like", value, "padId");
            return (Criteria) this;
        }

        public Criteria orPadIdLike(String value) {
            orCriterion("pad_id like", value, "padId");
            return (Criteria) this;
        }

        public Criteria orPadIdNotLike(String value) {
            orCriterion("pad_id not like", value, "padId");
            return (Criteria) this;
        }

        public Criteria andPadIdIn(List<String> values) {
            addCriterion("pad_id in", values, "padId");
            return (Criteria) this;
        }

        public Criteria andPadIdNotIn(List<String> values) {
            addCriterion("pad_id not in", values, "padId");
            return (Criteria) this;
        }

        public Criteria andPadIdBetween(String value1, String value2) {
            addCriterion("pad_id between", value1, value2, "padId");
            return (Criteria) this;
        }

        public Criteria andPadIdNotBetween(String value1, String value2) {
            addCriterion("pad_id not between", value1, value2, "padId");
            return (Criteria) this;
        }

        public Criteria orPadIdIn(List<String> values) {
            orCriterion("pad_id in", values, "padId");
            return (Criteria) this;
        }

        public Criteria orPadIdNotIn(List<String> values) {
            orCriterion("pad_id not in", values, "padId");
            return (Criteria) this;
        }

        public Criteria orPadIdBetween(String value1, String value2) {
            orCriterion("pad_id between", value1, value2, "padId");
            return (Criteria) this;
        }

        public Criteria orPadIdNotBetween(String value1, String value2) {
            orCriterion("pad_id not between", value1, value2, "padId");
            return (Criteria) this;
        }

        public Criteria andPosIdIsNull() {
            addCriterion("pos_id is null");
            return (Criteria) this;
        }

        public Criteria andPosIdIsNotNull() {
            addCriterion("pos_id is not null");
            return (Criteria) this;
        }

        public Criteria andPosIdEqualTo(String value) {
            addCriterion("pos_id =", value, "posId");
            return (Criteria) this;
        }

        public Criteria andPosIdNotEqualTo(String value) {
            addCriterion("pos_id <>", value, "posId");
            return (Criteria) this;
        }

        public Criteria andPosIdGreaterThan(String value) {
            addCriterion("pos_id >", value, "posId");
            return (Criteria) this;
        }

        public Criteria andPosIdGreaterThanOrEqualTo(String value) {
            addCriterion("pos_id >=", value, "posId");
            return (Criteria) this;
        }

        public Criteria andPosIdLessThan(String value) {
            addCriterion("pos_id <", value, "posId");
            return (Criteria) this;
        }

        public Criteria andPosIdLessThanOrEqualTo(String value) {
            addCriterion("pos_id <=", value, "posId");
            return (Criteria) this;
        }

        public Criteria orPosIdIsNull() {
            orCriterion("pos_id is null");
            return (Criteria) this;
        }

        public Criteria orPosIdIsNotNull() {
            orCriterion("pos_id is not null");
            return (Criteria) this;
        }

        public Criteria orPosIdEqualTo(String value) {
            orCriterion("pos_id =", value, "posId");
            return (Criteria) this;
        }

        public Criteria orPosIdNotEqualTo(String value) {
            orCriterion("pos_id <>", value, "posId");
            return (Criteria) this;
        }

        public Criteria orPosIdGreaterThan(String value) {
            orCriterion("pos_id >", value, "posId");
            return (Criteria) this;
        }

        public Criteria orPosIdGreaterThanOrEqualTo(String value) {
            orCriterion("pos_id >=", value, "posId");
            return (Criteria) this;
        }

        public Criteria orPosIdLessThan(String value) {
            orCriterion("pos_id <", value, "posId");
            return (Criteria) this;
        }

        public Criteria orPosIdLessThanOrEqualTo(String value) {
            orCriterion("pos_id <=", value, "posId");
            return (Criteria) this;
        }

        public Criteria andPosIdLike(String value) {
            addCriterion("pos_id like", value, "posId");
            return (Criteria) this;
        }

        public Criteria andPosIdNotLike(String value) {
            addCriterion("pos_id not like", value, "posId");
            return (Criteria) this;
        }

        public Criteria orPosIdLike(String value) {
            orCriterion("pos_id like", value, "posId");
            return (Criteria) this;
        }

        public Criteria orPosIdNotLike(String value) {
            orCriterion("pos_id not like", value, "posId");
            return (Criteria) this;
        }

        public Criteria andPosIdIn(List<String> values) {
            addCriterion("pos_id in", values, "posId");
            return (Criteria) this;
        }

        public Criteria andPosIdNotIn(List<String> values) {
            addCriterion("pos_id not in", values, "posId");
            return (Criteria) this;
        }

        public Criteria andPosIdBetween(String value1, String value2) {
            addCriterion("pos_id between", value1, value2, "posId");
            return (Criteria) this;
        }

        public Criteria andPosIdNotBetween(String value1, String value2) {
            addCriterion("pos_id not between", value1, value2, "posId");
            return (Criteria) this;
        }

        public Criteria orPosIdIn(List<String> values) {
            orCriterion("pos_id in", values, "posId");
            return (Criteria) this;
        }

        public Criteria orPosIdNotIn(List<String> values) {
            orCriterion("pos_id not in", values, "posId");
            return (Criteria) this;
        }

        public Criteria orPosIdBetween(String value1, String value2) {
            orCriterion("pos_id between", value1, value2, "posId");
            return (Criteria) this;
        }

        public Criteria orPosIdNotBetween(String value1, String value2) {
            orCriterion("pos_id not between", value1, value2, "posId");
            return (Criteria) this;
        }

        public Criteria andOrgIdIsNull() {
            addCriterion("org_id is null");
            return (Criteria) this;
        }

        public Criteria andOrgIdIsNotNull() {
            addCriterion("org_id is not null");
            return (Criteria) this;
        }

        public Criteria andOrgIdEqualTo(String value) {
            addCriterion("org_id =", value, "orgId");
            return (Criteria) this;
        }

        public Criteria andOrgIdNotEqualTo(String value) {
            addCriterion("org_id <>", value, "orgId");
            return (Criteria) this;
        }

        public Criteria andOrgIdGreaterThan(String value) {
            addCriterion("org_id >", value, "orgId");
            return (Criteria) this;
        }

        public Criteria andOrgIdGreaterThanOrEqualTo(String value) {
            addCriterion("org_id >=", value, "orgId");
            return (Criteria) this;
        }

        public Criteria andOrgIdLessThan(String value) {
            addCriterion("org_id <", value, "orgId");
            return (Criteria) this;
        }

        public Criteria andOrgIdLessThanOrEqualTo(String value) {
            addCriterion("org_id <=", value, "orgId");
            return (Criteria) this;
        }

        public Criteria orOrgIdIsNull() {
            orCriterion("org_id is null");
            return (Criteria) this;
        }

        public Criteria orOrgIdIsNotNull() {
            orCriterion("org_id is not null");
            return (Criteria) this;
        }

        public Criteria orOrgIdEqualTo(String value) {
            orCriterion("org_id =", value, "orgId");
            return (Criteria) this;
        }

        public Criteria orOrgIdNotEqualTo(String value) {
            orCriterion("org_id <>", value, "orgId");
            return (Criteria) this;
        }

        public Criteria orOrgIdGreaterThan(String value) {
            orCriterion("org_id >", value, "orgId");
            return (Criteria) this;
        }

        public Criteria orOrgIdGreaterThanOrEqualTo(String value) {
            orCriterion("org_id >=", value, "orgId");
            return (Criteria) this;
        }

        public Criteria orOrgIdLessThan(String value) {
            orCriterion("org_id <", value, "orgId");
            return (Criteria) this;
        }

        public Criteria orOrgIdLessThanOrEqualTo(String value) {
            orCriterion("org_id <=", value, "orgId");
            return (Criteria) this;
        }

        public Criteria andOrgIdLike(String value) {
            addCriterion("org_id like", value, "orgId");
            return (Criteria) this;
        }

        public Criteria andOrgIdNotLike(String value) {
            addCriterion("org_id not like", value, "orgId");
            return (Criteria) this;
        }

        public Criteria orOrgIdLike(String value) {
            orCriterion("org_id like", value, "orgId");
            return (Criteria) this;
        }

        public Criteria orOrgIdNotLike(String value) {
            orCriterion("org_id not like", value, "orgId");
            return (Criteria) this;
        }

        public Criteria andOrgIdIn(List<String> values) {
            addCriterion("org_id in", values, "orgId");
            return (Criteria) this;
        }

        public Criteria andOrgIdNotIn(List<String> values) {
            addCriterion("org_id not in", values, "orgId");
            return (Criteria) this;
        }

        public Criteria andOrgIdBetween(String value1, String value2) {
            addCriterion("org_id between", value1, value2, "orgId");
            return (Criteria) this;
        }

        public Criteria andOrgIdNotBetween(String value1, String value2) {
            addCriterion("org_id not between", value1, value2, "orgId");
            return (Criteria) this;
        }

        public Criteria orOrgIdIn(List<String> values) {
            orCriterion("org_id in", values, "orgId");
            return (Criteria) this;
        }

        public Criteria orOrgIdNotIn(List<String> values) {
            orCriterion("org_id not in", values, "orgId");
            return (Criteria) this;
        }

        public Criteria orOrgIdBetween(String value1, String value2) {
            orCriterion("org_id between", value1, value2, "orgId");
            return (Criteria) this;
        }

        public Criteria orOrgIdNotBetween(String value1, String value2) {
            orCriterion("org_id not between", value1, value2, "orgId");
            return (Criteria) this;
        }

        public Criteria andPaidAmountIsNull() {
            addCriterion("paid_amount is null");
            return (Criteria) this;
        }

        public Criteria andPaidAmountIsNotNull() {
            addCriterion("paid_amount is not null");
            return (Criteria) this;
        }

        public Criteria andPaidAmountEqualTo(BigDecimal value) {
            addCriterion("paid_amount =", value, "paidAmount");
            return (Criteria) this;
        }

        public Criteria andPaidAmountNotEqualTo(BigDecimal value) {
            addCriterion("paid_amount <>", value, "paidAmount");
            return (Criteria) this;
        }

        public Criteria andPaidAmountGreaterThan(BigDecimal value) {
            addCriterion("paid_amount >", value, "paidAmount");
            return (Criteria) this;
        }

        public Criteria andPaidAmountGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("paid_amount >=", value, "paidAmount");
            return (Criteria) this;
        }

        public Criteria andPaidAmountLessThan(BigDecimal value) {
            addCriterion("paid_amount <", value, "paidAmount");
            return (Criteria) this;
        }

        public Criteria andPaidAmountLessThanOrEqualTo(BigDecimal value) {
            addCriterion("paid_amount <=", value, "paidAmount");
            return (Criteria) this;
        }

        public Criteria orPaidAmountIsNull() {
            orCriterion("paid_amount is null");
            return (Criteria) this;
        }

        public Criteria orPaidAmountIsNotNull() {
            orCriterion("paid_amount is not null");
            return (Criteria) this;
        }

        public Criteria orPaidAmountEqualTo(BigDecimal value) {
            orCriterion("paid_amount =", value, "paidAmount");
            return (Criteria) this;
        }

        public Criteria orPaidAmountNotEqualTo(BigDecimal value) {
            orCriterion("paid_amount <>", value, "paidAmount");
            return (Criteria) this;
        }

        public Criteria orPaidAmountGreaterThan(BigDecimal value) {
            orCriterion("paid_amount >", value, "paidAmount");
            return (Criteria) this;
        }

        public Criteria orPaidAmountGreaterThanOrEqualTo(BigDecimal value) {
            orCriterion("paid_amount >=", value, "paidAmount");
            return (Criteria) this;
        }

        public Criteria orPaidAmountLessThan(BigDecimal value) {
            orCriterion("paid_amount <", value, "paidAmount");
            return (Criteria) this;
        }

        public Criteria orPaidAmountLessThanOrEqualTo(BigDecimal value) {
            orCriterion("paid_amount <=", value, "paidAmount");
            return (Criteria) this;
        }

        public Criteria andPaidAmountIn(List<BigDecimal> values) {
            addCriterion("paid_amount in", values, "paidAmount");
            return (Criteria) this;
        }

        public Criteria andPaidAmountNotIn(List<BigDecimal> values) {
            addCriterion("paid_amount not in", values, "paidAmount");
            return (Criteria) this;
        }

        public Criteria andPaidAmountBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("paid_amount between", value1, value2, "paidAmount");
            return (Criteria) this;
        }

        public Criteria andPaidAmountNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("paid_amount not between", value1, value2, "paidAmount");
            return (Criteria) this;
        }

        public Criteria orPaidAmountIn(List<BigDecimal> values) {
            orCriterion("paid_amount in", values, "paidAmount");
            return (Criteria) this;
        }

        public Criteria orPaidAmountNotIn(List<BigDecimal> values) {
            orCriterion("paid_amount not in", values, "paidAmount");
            return (Criteria) this;
        }

        public Criteria orPaidAmountBetween(BigDecimal value1, BigDecimal value2) {
            orCriterion("paid_amount between", value1, value2, "paidAmount");
            return (Criteria) this;
        }

        public Criteria orPaidAmountNotBetween(BigDecimal value1, BigDecimal value2) {
            orCriterion("paid_amount not between", value1, value2, "paidAmount");
            return (Criteria) this;
        }

        public Criteria andIdcardFrontIsNull() {
            addCriterion("idcard_front is null");
            return (Criteria) this;
        }

        public Criteria andIdcardFrontIsNotNull() {
            addCriterion("idcard_front is not null");
            return (Criteria) this;
        }

        public Criteria andIdcardFrontEqualTo(String value) {
            addCriterion("idcard_front =", value, "idcardFront");
            return (Criteria) this;
        }

        public Criteria andIdcardFrontNotEqualTo(String value) {
            addCriterion("idcard_front <>", value, "idcardFront");
            return (Criteria) this;
        }

        public Criteria andIdcardFrontGreaterThan(String value) {
            addCriterion("idcard_front >", value, "idcardFront");
            return (Criteria) this;
        }

        public Criteria andIdcardFrontGreaterThanOrEqualTo(String value) {
            addCriterion("idcard_front >=", value, "idcardFront");
            return (Criteria) this;
        }

        public Criteria andIdcardFrontLessThan(String value) {
            addCriterion("idcard_front <", value, "idcardFront");
            return (Criteria) this;
        }

        public Criteria andIdcardFrontLessThanOrEqualTo(String value) {
            addCriterion("idcard_front <=", value, "idcardFront");
            return (Criteria) this;
        }

        public Criteria orIdcardFrontIsNull() {
            orCriterion("idcard_front is null");
            return (Criteria) this;
        }

        public Criteria orIdcardFrontIsNotNull() {
            orCriterion("idcard_front is not null");
            return (Criteria) this;
        }

        public Criteria orIdcardFrontEqualTo(String value) {
            orCriterion("idcard_front =", value, "idcardFront");
            return (Criteria) this;
        }

        public Criteria orIdcardFrontNotEqualTo(String value) {
            orCriterion("idcard_front <>", value, "idcardFront");
            return (Criteria) this;
        }

        public Criteria orIdcardFrontGreaterThan(String value) {
            orCriterion("idcard_front >", value, "idcardFront");
            return (Criteria) this;
        }

        public Criteria orIdcardFrontGreaterThanOrEqualTo(String value) {
            orCriterion("idcard_front >=", value, "idcardFront");
            return (Criteria) this;
        }

        public Criteria orIdcardFrontLessThan(String value) {
            orCriterion("idcard_front <", value, "idcardFront");
            return (Criteria) this;
        }

        public Criteria orIdcardFrontLessThanOrEqualTo(String value) {
            orCriterion("idcard_front <=", value, "idcardFront");
            return (Criteria) this;
        }

        public Criteria andIdcardFrontLike(String value) {
            addCriterion("idcard_front like", value, "idcardFront");
            return (Criteria) this;
        }

        public Criteria andIdcardFrontNotLike(String value) {
            addCriterion("idcard_front not like", value, "idcardFront");
            return (Criteria) this;
        }

        public Criteria orIdcardFrontLike(String value) {
            orCriterion("idcard_front like", value, "idcardFront");
            return (Criteria) this;
        }

        public Criteria orIdcardFrontNotLike(String value) {
            orCriterion("idcard_front not like", value, "idcardFront");
            return (Criteria) this;
        }

        public Criteria andIdcardFrontIn(List<String> values) {
            addCriterion("idcard_front in", values, "idcardFront");
            return (Criteria) this;
        }

        public Criteria andIdcardFrontNotIn(List<String> values) {
            addCriterion("idcard_front not in", values, "idcardFront");
            return (Criteria) this;
        }

        public Criteria andIdcardFrontBetween(String value1, String value2) {
            addCriterion("idcard_front between", value1, value2, "idcardFront");
            return (Criteria) this;
        }

        public Criteria andIdcardFrontNotBetween(String value1, String value2) {
            addCriterion("idcard_front not between", value1, value2, "idcardFront");
            return (Criteria) this;
        }

        public Criteria orIdcardFrontIn(List<String> values) {
            orCriterion("idcard_front in", values, "idcardFront");
            return (Criteria) this;
        }

        public Criteria orIdcardFrontNotIn(List<String> values) {
            orCriterion("idcard_front not in", values, "idcardFront");
            return (Criteria) this;
        }

        public Criteria orIdcardFrontBetween(String value1, String value2) {
            orCriterion("idcard_front between", value1, value2, "idcardFront");
            return (Criteria) this;
        }

        public Criteria orIdcardFrontNotBetween(String value1, String value2) {
            orCriterion("idcard_front not between", value1, value2, "idcardFront");
            return (Criteria) this;
        }

        public Criteria andIdcardBackIsNull() {
            addCriterion("idcard_back is null");
            return (Criteria) this;
        }

        public Criteria andIdcardBackIsNotNull() {
            addCriterion("idcard_back is not null");
            return (Criteria) this;
        }

        public Criteria andIdcardBackEqualTo(String value) {
            addCriterion("idcard_back =", value, "idcardBack");
            return (Criteria) this;
        }

        public Criteria andIdcardBackNotEqualTo(String value) {
            addCriterion("idcard_back <>", value, "idcardBack");
            return (Criteria) this;
        }

        public Criteria andIdcardBackGreaterThan(String value) {
            addCriterion("idcard_back >", value, "idcardBack");
            return (Criteria) this;
        }

        public Criteria andIdcardBackGreaterThanOrEqualTo(String value) {
            addCriterion("idcard_back >=", value, "idcardBack");
            return (Criteria) this;
        }

        public Criteria andIdcardBackLessThan(String value) {
            addCriterion("idcard_back <", value, "idcardBack");
            return (Criteria) this;
        }

        public Criteria andIdcardBackLessThanOrEqualTo(String value) {
            addCriterion("idcard_back <=", value, "idcardBack");
            return (Criteria) this;
        }

        public Criteria orIdcardBackIsNull() {
            orCriterion("idcard_back is null");
            return (Criteria) this;
        }

        public Criteria orIdcardBackIsNotNull() {
            orCriterion("idcard_back is not null");
            return (Criteria) this;
        }

        public Criteria orIdcardBackEqualTo(String value) {
            orCriterion("idcard_back =", value, "idcardBack");
            return (Criteria) this;
        }

        public Criteria orIdcardBackNotEqualTo(String value) {
            orCriterion("idcard_back <>", value, "idcardBack");
            return (Criteria) this;
        }

        public Criteria orIdcardBackGreaterThan(String value) {
            orCriterion("idcard_back >", value, "idcardBack");
            return (Criteria) this;
        }

        public Criteria orIdcardBackGreaterThanOrEqualTo(String value) {
            orCriterion("idcard_back >=", value, "idcardBack");
            return (Criteria) this;
        }

        public Criteria orIdcardBackLessThan(String value) {
            orCriterion("idcard_back <", value, "idcardBack");
            return (Criteria) this;
        }

        public Criteria orIdcardBackLessThanOrEqualTo(String value) {
            orCriterion("idcard_back <=", value, "idcardBack");
            return (Criteria) this;
        }

        public Criteria andIdcardBackLike(String value) {
            addCriterion("idcard_back like", value, "idcardBack");
            return (Criteria) this;
        }

        public Criteria andIdcardBackNotLike(String value) {
            addCriterion("idcard_back not like", value, "idcardBack");
            return (Criteria) this;
        }

        public Criteria orIdcardBackLike(String value) {
            orCriterion("idcard_back like", value, "idcardBack");
            return (Criteria) this;
        }

        public Criteria orIdcardBackNotLike(String value) {
            orCriterion("idcard_back not like", value, "idcardBack");
            return (Criteria) this;
        }

        public Criteria andIdcardBackIn(List<String> values) {
            addCriterion("idcard_back in", values, "idcardBack");
            return (Criteria) this;
        }

        public Criteria andIdcardBackNotIn(List<String> values) {
            addCriterion("idcard_back not in", values, "idcardBack");
            return (Criteria) this;
        }

        public Criteria andIdcardBackBetween(String value1, String value2) {
            addCriterion("idcard_back between", value1, value2, "idcardBack");
            return (Criteria) this;
        }

        public Criteria andIdcardBackNotBetween(String value1, String value2) {
            addCriterion("idcard_back not between", value1, value2, "idcardBack");
            return (Criteria) this;
        }

        public Criteria orIdcardBackIn(List<String> values) {
            orCriterion("idcard_back in", values, "idcardBack");
            return (Criteria) this;
        }

        public Criteria orIdcardBackNotIn(List<String> values) {
            orCriterion("idcard_back not in", values, "idcardBack");
            return (Criteria) this;
        }

        public Criteria orIdcardBackBetween(String value1, String value2) {
            orCriterion("idcard_back between", value1, value2, "idcardBack");
            return (Criteria) this;
        }

        public Criteria orIdcardBackNotBetween(String value1, String value2) {
            orCriterion("idcard_back not between", value1, value2, "idcardBack");
            return (Criteria) this;
        }

        public Criteria andContactSignManagerIsNull() {
            addCriterion("contact_sign_manager is null");
            return (Criteria) this;
        }

        public Criteria andContactSignManagerIsNotNull() {
            addCriterion("contact_sign_manager is not null");
            return (Criteria) this;
        }

        public Criteria andContactSignManagerEqualTo(String value) {
            addCriterion("contact_sign_manager =", value, "contactSignManager");
            return (Criteria) this;
        }

        public Criteria andContactSignManagerNotEqualTo(String value) {
            addCriterion("contact_sign_manager <>", value, "contactSignManager");
            return (Criteria) this;
        }

        public Criteria andContactSignManagerGreaterThan(String value) {
            addCriterion("contact_sign_manager >", value, "contactSignManager");
            return (Criteria) this;
        }

        public Criteria andContactSignManagerGreaterThanOrEqualTo(String value) {
            addCriterion("contact_sign_manager >=", value, "contactSignManager");
            return (Criteria) this;
        }

        public Criteria andContactSignManagerLessThan(String value) {
            addCriterion("contact_sign_manager <", value, "contactSignManager");
            return (Criteria) this;
        }

        public Criteria andContactSignManagerLessThanOrEqualTo(String value) {
            addCriterion("contact_sign_manager <=", value, "contactSignManager");
            return (Criteria) this;
        }

        public Criteria orContactSignManagerIsNull() {
            orCriterion("contact_sign_manager is null");
            return (Criteria) this;
        }

        public Criteria orContactSignManagerIsNotNull() {
            orCriterion("contact_sign_manager is not null");
            return (Criteria) this;
        }

        public Criteria orContactSignManagerEqualTo(String value) {
            orCriterion("contact_sign_manager =", value, "contactSignManager");
            return (Criteria) this;
        }

        public Criteria orContactSignManagerNotEqualTo(String value) {
            orCriterion("contact_sign_manager <>", value, "contactSignManager");
            return (Criteria) this;
        }

        public Criteria orContactSignManagerGreaterThan(String value) {
            orCriterion("contact_sign_manager >", value, "contactSignManager");
            return (Criteria) this;
        }

        public Criteria orContactSignManagerGreaterThanOrEqualTo(String value) {
            orCriterion("contact_sign_manager >=", value, "contactSignManager");
            return (Criteria) this;
        }

        public Criteria orContactSignManagerLessThan(String value) {
            orCriterion("contact_sign_manager <", value, "contactSignManager");
            return (Criteria) this;
        }

        public Criteria orContactSignManagerLessThanOrEqualTo(String value) {
            orCriterion("contact_sign_manager <=", value, "contactSignManager");
            return (Criteria) this;
        }

        public Criteria andContactSignManagerLike(String value) {
            addCriterion("contact_sign_manager like", value, "contactSignManager");
            return (Criteria) this;
        }

        public Criteria andContactSignManagerNotLike(String value) {
            addCriterion("contact_sign_manager not like", value, "contactSignManager");
            return (Criteria) this;
        }

        public Criteria orContactSignManagerLike(String value) {
            orCriterion("contact_sign_manager like", value, "contactSignManager");
            return (Criteria) this;
        }

        public Criteria orContactSignManagerNotLike(String value) {
            orCriterion("contact_sign_manager not like", value, "contactSignManager");
            return (Criteria) this;
        }

        public Criteria andContactSignManagerIn(List<String> values) {
            addCriterion("contact_sign_manager in", values, "contactSignManager");
            return (Criteria) this;
        }

        public Criteria andContactSignManagerNotIn(List<String> values) {
            addCriterion("contact_sign_manager not in", values, "contactSignManager");
            return (Criteria) this;
        }

        public Criteria andContactSignManagerBetween(String value1, String value2) {
            addCriterion("contact_sign_manager between", value1, value2, "contactSignManager");
            return (Criteria) this;
        }

        public Criteria andContactSignManagerNotBetween(String value1, String value2) {
            addCriterion("contact_sign_manager not between", value1, value2, "contactSignManager");
            return (Criteria) this;
        }

        public Criteria orContactSignManagerIn(List<String> values) {
            orCriterion("contact_sign_manager in", values, "contactSignManager");
            return (Criteria) this;
        }

        public Criteria orContactSignManagerNotIn(List<String> values) {
            orCriterion("contact_sign_manager not in", values, "contactSignManager");
            return (Criteria) this;
        }

        public Criteria orContactSignManagerBetween(String value1, String value2) {
            orCriterion("contact_sign_manager between", value1, value2, "contactSignManager");
            return (Criteria) this;
        }

        public Criteria orContactSignManagerNotBetween(String value1, String value2) {
            orCriterion("contact_sign_manager not between", value1, value2, "contactSignManager");
            return (Criteria) this;
        }

        public Criteria andContactSignUserIsNull() {
            addCriterion("contact_sign_user is null");
            return (Criteria) this;
        }

        public Criteria andContactSignUserIsNotNull() {
            addCriterion("contact_sign_user is not null");
            return (Criteria) this;
        }

        public Criteria andContactSignUserEqualTo(String value) {
            addCriterion("contact_sign_user =", value, "contactSignUser");
            return (Criteria) this;
        }

        public Criteria andContactSignUserNotEqualTo(String value) {
            addCriterion("contact_sign_user <>", value, "contactSignUser");
            return (Criteria) this;
        }

        public Criteria andContactSignUserGreaterThan(String value) {
            addCriterion("contact_sign_user >", value, "contactSignUser");
            return (Criteria) this;
        }

        public Criteria andContactSignUserGreaterThanOrEqualTo(String value) {
            addCriterion("contact_sign_user >=", value, "contactSignUser");
            return (Criteria) this;
        }

        public Criteria andContactSignUserLessThan(String value) {
            addCriterion("contact_sign_user <", value, "contactSignUser");
            return (Criteria) this;
        }

        public Criteria andContactSignUserLessThanOrEqualTo(String value) {
            addCriterion("contact_sign_user <=", value, "contactSignUser");
            return (Criteria) this;
        }

        public Criteria orContactSignUserIsNull() {
            orCriterion("contact_sign_user is null");
            return (Criteria) this;
        }

        public Criteria orContactSignUserIsNotNull() {
            orCriterion("contact_sign_user is not null");
            return (Criteria) this;
        }

        public Criteria orContactSignUserEqualTo(String value) {
            orCriterion("contact_sign_user =", value, "contactSignUser");
            return (Criteria) this;
        }

        public Criteria orContactSignUserNotEqualTo(String value) {
            orCriterion("contact_sign_user <>", value, "contactSignUser");
            return (Criteria) this;
        }

        public Criteria orContactSignUserGreaterThan(String value) {
            orCriterion("contact_sign_user >", value, "contactSignUser");
            return (Criteria) this;
        }

        public Criteria orContactSignUserGreaterThanOrEqualTo(String value) {
            orCriterion("contact_sign_user >=", value, "contactSignUser");
            return (Criteria) this;
        }

        public Criteria orContactSignUserLessThan(String value) {
            orCriterion("contact_sign_user <", value, "contactSignUser");
            return (Criteria) this;
        }

        public Criteria orContactSignUserLessThanOrEqualTo(String value) {
            orCriterion("contact_sign_user <=", value, "contactSignUser");
            return (Criteria) this;
        }

        public Criteria andContactSignUserLike(String value) {
            addCriterion("contact_sign_user like", value, "contactSignUser");
            return (Criteria) this;
        }

        public Criteria andContactSignUserNotLike(String value) {
            addCriterion("contact_sign_user not like", value, "contactSignUser");
            return (Criteria) this;
        }

        public Criteria orContactSignUserLike(String value) {
            orCriterion("contact_sign_user like", value, "contactSignUser");
            return (Criteria) this;
        }

        public Criteria orContactSignUserNotLike(String value) {
            orCriterion("contact_sign_user not like", value, "contactSignUser");
            return (Criteria) this;
        }

        public Criteria andContactSignUserIn(List<String> values) {
            addCriterion("contact_sign_user in", values, "contactSignUser");
            return (Criteria) this;
        }

        public Criteria andContactSignUserNotIn(List<String> values) {
            addCriterion("contact_sign_user not in", values, "contactSignUser");
            return (Criteria) this;
        }

        public Criteria andContactSignUserBetween(String value1, String value2) {
            addCriterion("contact_sign_user between", value1, value2, "contactSignUser");
            return (Criteria) this;
        }

        public Criteria andContactSignUserNotBetween(String value1, String value2) {
            addCriterion("contact_sign_user not between", value1, value2, "contactSignUser");
            return (Criteria) this;
        }

        public Criteria orContactSignUserIn(List<String> values) {
            orCriterion("contact_sign_user in", values, "contactSignUser");
            return (Criteria) this;
        }

        public Criteria orContactSignUserNotIn(List<String> values) {
            orCriterion("contact_sign_user not in", values, "contactSignUser");
            return (Criteria) this;
        }

        public Criteria orContactSignUserBetween(String value1, String value2) {
            orCriterion("contact_sign_user between", value1, value2, "contactSignUser");
            return (Criteria) this;
        }

        public Criteria orContactSignUserNotBetween(String value1, String value2) {
            orCriterion("contact_sign_user not between", value1, value2, "contactSignUser");
            return (Criteria) this;
        }

        public Criteria andPaySignManagerIsNull() {
            addCriterion("pay_sign_manager is null");
            return (Criteria) this;
        }

        public Criteria andPaySignManagerIsNotNull() {
            addCriterion("pay_sign_manager is not null");
            return (Criteria) this;
        }

        public Criteria andPaySignManagerEqualTo(String value) {
            addCriterion("pay_sign_manager =", value, "paySignManager");
            return (Criteria) this;
        }

        public Criteria andPaySignManagerNotEqualTo(String value) {
            addCriterion("pay_sign_manager <>", value, "paySignManager");
            return (Criteria) this;
        }

        public Criteria andPaySignManagerGreaterThan(String value) {
            addCriterion("pay_sign_manager >", value, "paySignManager");
            return (Criteria) this;
        }

        public Criteria andPaySignManagerGreaterThanOrEqualTo(String value) {
            addCriterion("pay_sign_manager >=", value, "paySignManager");
            return (Criteria) this;
        }

        public Criteria andPaySignManagerLessThan(String value) {
            addCriterion("pay_sign_manager <", value, "paySignManager");
            return (Criteria) this;
        }

        public Criteria andPaySignManagerLessThanOrEqualTo(String value) {
            addCriterion("pay_sign_manager <=", value, "paySignManager");
            return (Criteria) this;
        }

        public Criteria orPaySignManagerIsNull() {
            orCriterion("pay_sign_manager is null");
            return (Criteria) this;
        }

        public Criteria orPaySignManagerIsNotNull() {
            orCriterion("pay_sign_manager is not null");
            return (Criteria) this;
        }

        public Criteria orPaySignManagerEqualTo(String value) {
            orCriterion("pay_sign_manager =", value, "paySignManager");
            return (Criteria) this;
        }

        public Criteria orPaySignManagerNotEqualTo(String value) {
            orCriterion("pay_sign_manager <>", value, "paySignManager");
            return (Criteria) this;
        }

        public Criteria orPaySignManagerGreaterThan(String value) {
            orCriterion("pay_sign_manager >", value, "paySignManager");
            return (Criteria) this;
        }

        public Criteria orPaySignManagerGreaterThanOrEqualTo(String value) {
            orCriterion("pay_sign_manager >=", value, "paySignManager");
            return (Criteria) this;
        }

        public Criteria orPaySignManagerLessThan(String value) {
            orCriterion("pay_sign_manager <", value, "paySignManager");
            return (Criteria) this;
        }

        public Criteria orPaySignManagerLessThanOrEqualTo(String value) {
            orCriterion("pay_sign_manager <=", value, "paySignManager");
            return (Criteria) this;
        }

        public Criteria andPaySignManagerLike(String value) {
            addCriterion("pay_sign_manager like", value, "paySignManager");
            return (Criteria) this;
        }

        public Criteria andPaySignManagerNotLike(String value) {
            addCriterion("pay_sign_manager not like", value, "paySignManager");
            return (Criteria) this;
        }

        public Criteria orPaySignManagerLike(String value) {
            orCriterion("pay_sign_manager like", value, "paySignManager");
            return (Criteria) this;
        }

        public Criteria orPaySignManagerNotLike(String value) {
            orCriterion("pay_sign_manager not like", value, "paySignManager");
            return (Criteria) this;
        }

        public Criteria andPaySignManagerIn(List<String> values) {
            addCriterion("pay_sign_manager in", values, "paySignManager");
            return (Criteria) this;
        }

        public Criteria andPaySignManagerNotIn(List<String> values) {
            addCriterion("pay_sign_manager not in", values, "paySignManager");
            return (Criteria) this;
        }

        public Criteria andPaySignManagerBetween(String value1, String value2) {
            addCriterion("pay_sign_manager between", value1, value2, "paySignManager");
            return (Criteria) this;
        }

        public Criteria andPaySignManagerNotBetween(String value1, String value2) {
            addCriterion("pay_sign_manager not between", value1, value2, "paySignManager");
            return (Criteria) this;
        }

        public Criteria orPaySignManagerIn(List<String> values) {
            orCriterion("pay_sign_manager in", values, "paySignManager");
            return (Criteria) this;
        }

        public Criteria orPaySignManagerNotIn(List<String> values) {
            orCriterion("pay_sign_manager not in", values, "paySignManager");
            return (Criteria) this;
        }

        public Criteria orPaySignManagerBetween(String value1, String value2) {
            orCriterion("pay_sign_manager between", value1, value2, "paySignManager");
            return (Criteria) this;
        }

        public Criteria orPaySignManagerNotBetween(String value1, String value2) {
            orCriterion("pay_sign_manager not between", value1, value2, "paySignManager");
            return (Criteria) this;
        }

        public Criteria andPaySignUserIsNull() {
            addCriterion("pay_sign_user is null");
            return (Criteria) this;
        }

        public Criteria andPaySignUserIsNotNull() {
            addCriterion("pay_sign_user is not null");
            return (Criteria) this;
        }

        public Criteria andPaySignUserEqualTo(String value) {
            addCriterion("pay_sign_user =", value, "paySignUser");
            return (Criteria) this;
        }

        public Criteria andPaySignUserNotEqualTo(String value) {
            addCriterion("pay_sign_user <>", value, "paySignUser");
            return (Criteria) this;
        }

        public Criteria andPaySignUserGreaterThan(String value) {
            addCriterion("pay_sign_user >", value, "paySignUser");
            return (Criteria) this;
        }

        public Criteria andPaySignUserGreaterThanOrEqualTo(String value) {
            addCriterion("pay_sign_user >=", value, "paySignUser");
            return (Criteria) this;
        }

        public Criteria andPaySignUserLessThan(String value) {
            addCriterion("pay_sign_user <", value, "paySignUser");
            return (Criteria) this;
        }

        public Criteria andPaySignUserLessThanOrEqualTo(String value) {
            addCriterion("pay_sign_user <=", value, "paySignUser");
            return (Criteria) this;
        }

        public Criteria orPaySignUserIsNull() {
            orCriterion("pay_sign_user is null");
            return (Criteria) this;
        }

        public Criteria orPaySignUserIsNotNull() {
            orCriterion("pay_sign_user is not null");
            return (Criteria) this;
        }

        public Criteria orPaySignUserEqualTo(String value) {
            orCriterion("pay_sign_user =", value, "paySignUser");
            return (Criteria) this;
        }

        public Criteria orPaySignUserNotEqualTo(String value) {
            orCriterion("pay_sign_user <>", value, "paySignUser");
            return (Criteria) this;
        }

        public Criteria orPaySignUserGreaterThan(String value) {
            orCriterion("pay_sign_user >", value, "paySignUser");
            return (Criteria) this;
        }

        public Criteria orPaySignUserGreaterThanOrEqualTo(String value) {
            orCriterion("pay_sign_user >=", value, "paySignUser");
            return (Criteria) this;
        }

        public Criteria orPaySignUserLessThan(String value) {
            orCriterion("pay_sign_user <", value, "paySignUser");
            return (Criteria) this;
        }

        public Criteria orPaySignUserLessThanOrEqualTo(String value) {
            orCriterion("pay_sign_user <=", value, "paySignUser");
            return (Criteria) this;
        }

        public Criteria andPaySignUserLike(String value) {
            addCriterion("pay_sign_user like", value, "paySignUser");
            return (Criteria) this;
        }

        public Criteria andPaySignUserNotLike(String value) {
            addCriterion("pay_sign_user not like", value, "paySignUser");
            return (Criteria) this;
        }

        public Criteria orPaySignUserLike(String value) {
            orCriterion("pay_sign_user like", value, "paySignUser");
            return (Criteria) this;
        }

        public Criteria orPaySignUserNotLike(String value) {
            orCriterion("pay_sign_user not like", value, "paySignUser");
            return (Criteria) this;
        }

        public Criteria andPaySignUserIn(List<String> values) {
            addCriterion("pay_sign_user in", values, "paySignUser");
            return (Criteria) this;
        }

        public Criteria andPaySignUserNotIn(List<String> values) {
            addCriterion("pay_sign_user not in", values, "paySignUser");
            return (Criteria) this;
        }

        public Criteria andPaySignUserBetween(String value1, String value2) {
            addCriterion("pay_sign_user between", value1, value2, "paySignUser");
            return (Criteria) this;
        }

        public Criteria andPaySignUserNotBetween(String value1, String value2) {
            addCriterion("pay_sign_user not between", value1, value2, "paySignUser");
            return (Criteria) this;
        }

        public Criteria orPaySignUserIn(List<String> values) {
            orCriterion("pay_sign_user in", values, "paySignUser");
            return (Criteria) this;
        }

        public Criteria orPaySignUserNotIn(List<String> values) {
            orCriterion("pay_sign_user not in", values, "paySignUser");
            return (Criteria) this;
        }

        public Criteria orPaySignUserBetween(String value1, String value2) {
            orCriterion("pay_sign_user between", value1, value2, "paySignUser");
            return (Criteria) this;
        }

        public Criteria orPaySignUserNotBetween(String value1, String value2) {
            orCriterion("pay_sign_user not between", value1, value2, "paySignUser");
            return (Criteria) this;
        }

        public Criteria andVideoUserIsNull() {
            addCriterion("video_user is null");
            return (Criteria) this;
        }

        public Criteria andVideoUserIsNotNull() {
            addCriterion("video_user is not null");
            return (Criteria) this;
        }

        public Criteria andVideoUserEqualTo(String value) {
            addCriterion("video_user =", value, "videoUser");
            return (Criteria) this;
        }

        public Criteria andVideoUserNotEqualTo(String value) {
            addCriterion("video_user <>", value, "videoUser");
            return (Criteria) this;
        }

        public Criteria andVideoUserGreaterThan(String value) {
            addCriterion("video_user >", value, "videoUser");
            return (Criteria) this;
        }

        public Criteria andVideoUserGreaterThanOrEqualTo(String value) {
            addCriterion("video_user >=", value, "videoUser");
            return (Criteria) this;
        }

        public Criteria andVideoUserLessThan(String value) {
            addCriterion("video_user <", value, "videoUser");
            return (Criteria) this;
        }

        public Criteria andVideoUserLessThanOrEqualTo(String value) {
            addCriterion("video_user <=", value, "videoUser");
            return (Criteria) this;
        }

        public Criteria orVideoUserIsNull() {
            orCriterion("video_user is null");
            return (Criteria) this;
        }

        public Criteria orVideoUserIsNotNull() {
            orCriterion("video_user is not null");
            return (Criteria) this;
        }

        public Criteria orVideoUserEqualTo(String value) {
            orCriterion("video_user =", value, "videoUser");
            return (Criteria) this;
        }

        public Criteria orVideoUserNotEqualTo(String value) {
            orCriterion("video_user <>", value, "videoUser");
            return (Criteria) this;
        }

        public Criteria orVideoUserGreaterThan(String value) {
            orCriterion("video_user >", value, "videoUser");
            return (Criteria) this;
        }

        public Criteria orVideoUserGreaterThanOrEqualTo(String value) {
            orCriterion("video_user >=", value, "videoUser");
            return (Criteria) this;
        }

        public Criteria orVideoUserLessThan(String value) {
            orCriterion("video_user <", value, "videoUser");
            return (Criteria) this;
        }

        public Criteria orVideoUserLessThanOrEqualTo(String value) {
            orCriterion("video_user <=", value, "videoUser");
            return (Criteria) this;
        }

        public Criteria andVideoUserLike(String value) {
            addCriterion("video_user like", value, "videoUser");
            return (Criteria) this;
        }

        public Criteria andVideoUserNotLike(String value) {
            addCriterion("video_user not like", value, "videoUser");
            return (Criteria) this;
        }

        public Criteria orVideoUserLike(String value) {
            orCriterion("video_user like", value, "videoUser");
            return (Criteria) this;
        }

        public Criteria orVideoUserNotLike(String value) {
            orCriterion("video_user not like", value, "videoUser");
            return (Criteria) this;
        }

        public Criteria andVideoUserIn(List<String> values) {
            addCriterion("video_user in", values, "videoUser");
            return (Criteria) this;
        }

        public Criteria andVideoUserNotIn(List<String> values) {
            addCriterion("video_user not in", values, "videoUser");
            return (Criteria) this;
        }

        public Criteria andVideoUserBetween(String value1, String value2) {
            addCriterion("video_user between", value1, value2, "videoUser");
            return (Criteria) this;
        }

        public Criteria andVideoUserNotBetween(String value1, String value2) {
            addCriterion("video_user not between", value1, value2, "videoUser");
            return (Criteria) this;
        }

        public Criteria orVideoUserIn(List<String> values) {
            orCriterion("video_user in", values, "videoUser");
            return (Criteria) this;
        }

        public Criteria orVideoUserNotIn(List<String> values) {
            orCriterion("video_user not in", values, "videoUser");
            return (Criteria) this;
        }

        public Criteria orVideoUserBetween(String value1, String value2) {
            orCriterion("video_user between", value1, value2, "videoUser");
            return (Criteria) this;
        }

        public Criteria orVideoUserNotBetween(String value1, String value2) {
            orCriterion("video_user not between", value1, value2, "videoUser");
            return (Criteria) this;
        }

        public Criteria andVideoManagerIsNull() {
            addCriterion("video_manager is null");
            return (Criteria) this;
        }

        public Criteria andVideoManagerIsNotNull() {
            addCriterion("video_manager is not null");
            return (Criteria) this;
        }

        public Criteria andVideoManagerEqualTo(String value) {
            addCriterion("video_manager =", value, "videoManager");
            return (Criteria) this;
        }

        public Criteria andVideoManagerNotEqualTo(String value) {
            addCriterion("video_manager <>", value, "videoManager");
            return (Criteria) this;
        }

        public Criteria andVideoManagerGreaterThan(String value) {
            addCriterion("video_manager >", value, "videoManager");
            return (Criteria) this;
        }

        public Criteria andVideoManagerGreaterThanOrEqualTo(String value) {
            addCriterion("video_manager >=", value, "videoManager");
            return (Criteria) this;
        }

        public Criteria andVideoManagerLessThan(String value) {
            addCriterion("video_manager <", value, "videoManager");
            return (Criteria) this;
        }

        public Criteria andVideoManagerLessThanOrEqualTo(String value) {
            addCriterion("video_manager <=", value, "videoManager");
            return (Criteria) this;
        }

        public Criteria orVideoManagerIsNull() {
            orCriterion("video_manager is null");
            return (Criteria) this;
        }

        public Criteria orVideoManagerIsNotNull() {
            orCriterion("video_manager is not null");
            return (Criteria) this;
        }

        public Criteria orVideoManagerEqualTo(String value) {
            orCriterion("video_manager =", value, "videoManager");
            return (Criteria) this;
        }

        public Criteria orVideoManagerNotEqualTo(String value) {
            orCriterion("video_manager <>", value, "videoManager");
            return (Criteria) this;
        }

        public Criteria orVideoManagerGreaterThan(String value) {
            orCriterion("video_manager >", value, "videoManager");
            return (Criteria) this;
        }

        public Criteria orVideoManagerGreaterThanOrEqualTo(String value) {
            orCriterion("video_manager >=", value, "videoManager");
            return (Criteria) this;
        }

        public Criteria orVideoManagerLessThan(String value) {
            orCriterion("video_manager <", value, "videoManager");
            return (Criteria) this;
        }

        public Criteria orVideoManagerLessThanOrEqualTo(String value) {
            orCriterion("video_manager <=", value, "videoManager");
            return (Criteria) this;
        }

        public Criteria andVideoManagerLike(String value) {
            addCriterion("video_manager like", value, "videoManager");
            return (Criteria) this;
        }

        public Criteria andVideoManagerNotLike(String value) {
            addCriterion("video_manager not like", value, "videoManager");
            return (Criteria) this;
        }

        public Criteria orVideoManagerLike(String value) {
            orCriterion("video_manager like", value, "videoManager");
            return (Criteria) this;
        }

        public Criteria orVideoManagerNotLike(String value) {
            orCriterion("video_manager not like", value, "videoManager");
            return (Criteria) this;
        }

        public Criteria andVideoManagerIn(List<String> values) {
            addCriterion("video_manager in", values, "videoManager");
            return (Criteria) this;
        }

        public Criteria andVideoManagerNotIn(List<String> values) {
            addCriterion("video_manager not in", values, "videoManager");
            return (Criteria) this;
        }

        public Criteria andVideoManagerBetween(String value1, String value2) {
            addCriterion("video_manager between", value1, value2, "videoManager");
            return (Criteria) this;
        }

        public Criteria andVideoManagerNotBetween(String value1, String value2) {
            addCriterion("video_manager not between", value1, value2, "videoManager");
            return (Criteria) this;
        }

        public Criteria orVideoManagerIn(List<String> values) {
            orCriterion("video_manager in", values, "videoManager");
            return (Criteria) this;
        }

        public Criteria orVideoManagerNotIn(List<String> values) {
            orCriterion("video_manager not in", values, "videoManager");
            return (Criteria) this;
        }

        public Criteria orVideoManagerBetween(String value1, String value2) {
            orCriterion("video_manager between", value1, value2, "videoManager");
            return (Criteria) this;
        }

        public Criteria orVideoManagerNotBetween(String value1, String value2) {
            orCriterion("video_manager not between", value1, value2, "videoManager");
            return (Criteria) this;
        }

        public Criteria andStateIsNull() {
            addCriterion("state is null");
            return (Criteria) this;
        }

        public Criteria andStateIsNotNull() {
            addCriterion("state is not null");
            return (Criteria) this;
        }

        public Criteria andStateEqualTo(Integer value) {
            addCriterion("state =", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateNotEqualTo(Integer value) {
            addCriterion("state <>", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateGreaterThan(Integer value) {
            addCriterion("state >", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateGreaterThanOrEqualTo(Integer value) {
            addCriterion("state >=", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateLessThan(Integer value) {
            addCriterion("state <", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateLessThanOrEqualTo(Integer value) {
            addCriterion("state <=", value, "state");
            return (Criteria) this;
        }

        public Criteria orStateIsNull() {
            orCriterion("state is null");
            return (Criteria) this;
        }

        public Criteria orStateIsNotNull() {
            orCriterion("state is not null");
            return (Criteria) this;
        }

        public Criteria orStateEqualTo(Integer value) {
            orCriterion("state =", value, "state");
            return (Criteria) this;
        }

        public Criteria orStateNotEqualTo(Integer value) {
            orCriterion("state <>", value, "state");
            return (Criteria) this;
        }

        public Criteria orStateGreaterThan(Integer value) {
            orCriterion("state >", value, "state");
            return (Criteria) this;
        }

        public Criteria orStateGreaterThanOrEqualTo(Integer value) {
            orCriterion("state >=", value, "state");
            return (Criteria) this;
        }

        public Criteria orStateLessThan(Integer value) {
            orCriterion("state <", value, "state");
            return (Criteria) this;
        }

        public Criteria orStateLessThanOrEqualTo(Integer value) {
            orCriterion("state <=", value, "state");
            return (Criteria) this;
        }

        public Criteria andStateIn(List<Integer> values) {
            addCriterion("state in", values, "state");
            return (Criteria) this;
        }

        public Criteria andStateNotIn(List<Integer> values) {
            addCriterion("state not in", values, "state");
            return (Criteria) this;
        }

        public Criteria andStateBetween(Integer value1, Integer value2) {
            addCriterion("state between", value1, value2, "state");
            return (Criteria) this;
        }

        public Criteria andStateNotBetween(Integer value1, Integer value2) {
            addCriterion("state not between", value1, value2, "state");
            return (Criteria) this;
        }

        public Criteria orStateIn(List<Integer> values) {
            orCriterion("state in", values, "state");
            return (Criteria) this;
        }

        public Criteria orStateNotIn(List<Integer> values) {
            orCriterion("state not in", values, "state");
            return (Criteria) this;
        }

        public Criteria orStateBetween(Integer value1, Integer value2) {
            orCriterion("state between", value1, value2, "state");
            return (Criteria) this;
        }

        public Criteria orStateNotBetween(Integer value1, Integer value2) {
            orCriterion("state not between", value1, value2, "state");
            return (Criteria) this;
        }

        public Criteria andBankDepositIsNull() {
            addCriterion("bank_deposit is null");
            return (Criteria) this;
        }

        public Criteria andBankDepositIsNotNull() {
            addCriterion("bank_deposit is not null");
            return (Criteria) this;
        }

        public Criteria andBankDepositEqualTo(String value) {
            addCriterion("bank_deposit =", value, "bankDeposit");
            return (Criteria) this;
        }

        public Criteria andBankDepositNotEqualTo(String value) {
            addCriterion("bank_deposit <>", value, "bankDeposit");
            return (Criteria) this;
        }

        public Criteria andBankDepositGreaterThan(String value) {
            addCriterion("bank_deposit >", value, "bankDeposit");
            return (Criteria) this;
        }

        public Criteria andBankDepositGreaterThanOrEqualTo(String value) {
            addCriterion("bank_deposit >=", value, "bankDeposit");
            return (Criteria) this;
        }

        public Criteria andBankDepositLessThan(String value) {
            addCriterion("bank_deposit <", value, "bankDeposit");
            return (Criteria) this;
        }

        public Criteria andBankDepositLessThanOrEqualTo(String value) {
            addCriterion("bank_deposit <=", value, "bankDeposit");
            return (Criteria) this;
        }

        public Criteria orBankDepositIsNull() {
            orCriterion("bank_deposit is null");
            return (Criteria) this;
        }

        public Criteria orBankDepositIsNotNull() {
            orCriterion("bank_deposit is not null");
            return (Criteria) this;
        }

        public Criteria orBankDepositEqualTo(String value) {
            orCriterion("bank_deposit =", value, "bankDeposit");
            return (Criteria) this;
        }

        public Criteria orBankDepositNotEqualTo(String value) {
            orCriterion("bank_deposit <>", value, "bankDeposit");
            return (Criteria) this;
        }

        public Criteria orBankDepositGreaterThan(String value) {
            orCriterion("bank_deposit >", value, "bankDeposit");
            return (Criteria) this;
        }

        public Criteria orBankDepositGreaterThanOrEqualTo(String value) {
            orCriterion("bank_deposit >=", value, "bankDeposit");
            return (Criteria) this;
        }

        public Criteria orBankDepositLessThan(String value) {
            orCriterion("bank_deposit <", value, "bankDeposit");
            return (Criteria) this;
        }

        public Criteria orBankDepositLessThanOrEqualTo(String value) {
            orCriterion("bank_deposit <=", value, "bankDeposit");
            return (Criteria) this;
        }

        public Criteria andBankDepositLike(String value) {
            addCriterion("bank_deposit like", value, "bankDeposit");
            return (Criteria) this;
        }

        public Criteria andBankDepositNotLike(String value) {
            addCriterion("bank_deposit not like", value, "bankDeposit");
            return (Criteria) this;
        }

        public Criteria orBankDepositLike(String value) {
            orCriterion("bank_deposit like", value, "bankDeposit");
            return (Criteria) this;
        }

        public Criteria orBankDepositNotLike(String value) {
            orCriterion("bank_deposit not like", value, "bankDeposit");
            return (Criteria) this;
        }

        public Criteria andBankDepositIn(List<String> values) {
            addCriterion("bank_deposit in", values, "bankDeposit");
            return (Criteria) this;
        }

        public Criteria andBankDepositNotIn(List<String> values) {
            addCriterion("bank_deposit not in", values, "bankDeposit");
            return (Criteria) this;
        }

        public Criteria andBankDepositBetween(String value1, String value2) {
            addCriterion("bank_deposit between", value1, value2, "bankDeposit");
            return (Criteria) this;
        }

        public Criteria andBankDepositNotBetween(String value1, String value2) {
            addCriterion("bank_deposit not between", value1, value2, "bankDeposit");
            return (Criteria) this;
        }

        public Criteria orBankDepositIn(List<String> values) {
            orCriterion("bank_deposit in", values, "bankDeposit");
            return (Criteria) this;
        }

        public Criteria orBankDepositNotIn(List<String> values) {
            orCriterion("bank_deposit not in", values, "bankDeposit");
            return (Criteria) this;
        }

        public Criteria orBankDepositBetween(String value1, String value2) {
            orCriterion("bank_deposit between", value1, value2, "bankDeposit");
            return (Criteria) this;
        }

        public Criteria orBankDepositNotBetween(String value1, String value2) {
            orCriterion("bank_deposit not between", value1, value2, "bankDeposit");
            return (Criteria) this;
        }

        public Criteria andBankAccountIsNull() {
            addCriterion("bank_account is null");
            return (Criteria) this;
        }

        public Criteria andBankAccountIsNotNull() {
            addCriterion("bank_account is not null");
            return (Criteria) this;
        }

        public Criteria andBankAccountEqualTo(String value) {
            addCriterion("bank_account =", value, "bankAccount");
            return (Criteria) this;
        }

        public Criteria andBankAccountNotEqualTo(String value) {
            addCriterion("bank_account <>", value, "bankAccount");
            return (Criteria) this;
        }

        public Criteria andBankAccountGreaterThan(String value) {
            addCriterion("bank_account >", value, "bankAccount");
            return (Criteria) this;
        }

        public Criteria andBankAccountGreaterThanOrEqualTo(String value) {
            addCriterion("bank_account >=", value, "bankAccount");
            return (Criteria) this;
        }

        public Criteria andBankAccountLessThan(String value) {
            addCriterion("bank_account <", value, "bankAccount");
            return (Criteria) this;
        }

        public Criteria andBankAccountLessThanOrEqualTo(String value) {
            addCriterion("bank_account <=", value, "bankAccount");
            return (Criteria) this;
        }

        public Criteria orBankAccountIsNull() {
            orCriterion("bank_account is null");
            return (Criteria) this;
        }

        public Criteria orBankAccountIsNotNull() {
            orCriterion("bank_account is not null");
            return (Criteria) this;
        }

        public Criteria orBankAccountEqualTo(String value) {
            orCriterion("bank_account =", value, "bankAccount");
            return (Criteria) this;
        }

        public Criteria orBankAccountNotEqualTo(String value) {
            orCriterion("bank_account <>", value, "bankAccount");
            return (Criteria) this;
        }

        public Criteria orBankAccountGreaterThan(String value) {
            orCriterion("bank_account >", value, "bankAccount");
            return (Criteria) this;
        }

        public Criteria orBankAccountGreaterThanOrEqualTo(String value) {
            orCriterion("bank_account >=", value, "bankAccount");
            return (Criteria) this;
        }

        public Criteria orBankAccountLessThan(String value) {
            orCriterion("bank_account <", value, "bankAccount");
            return (Criteria) this;
        }

        public Criteria orBankAccountLessThanOrEqualTo(String value) {
            orCriterion("bank_account <=", value, "bankAccount");
            return (Criteria) this;
        }

        public Criteria andBankAccountLike(String value) {
            addCriterion("bank_account like", value, "bankAccount");
            return (Criteria) this;
        }

        public Criteria andBankAccountNotLike(String value) {
            addCriterion("bank_account not like", value, "bankAccount");
            return (Criteria) this;
        }

        public Criteria orBankAccountLike(String value) {
            orCriterion("bank_account like", value, "bankAccount");
            return (Criteria) this;
        }

        public Criteria orBankAccountNotLike(String value) {
            orCriterion("bank_account not like", value, "bankAccount");
            return (Criteria) this;
        }

        public Criteria andBankAccountIn(List<String> values) {
            addCriterion("bank_account in", values, "bankAccount");
            return (Criteria) this;
        }

        public Criteria andBankAccountNotIn(List<String> values) {
            addCriterion("bank_account not in", values, "bankAccount");
            return (Criteria) this;
        }

        public Criteria andBankAccountBetween(String value1, String value2) {
            addCriterion("bank_account between", value1, value2, "bankAccount");
            return (Criteria) this;
        }

        public Criteria andBankAccountNotBetween(String value1, String value2) {
            addCriterion("bank_account not between", value1, value2, "bankAccount");
            return (Criteria) this;
        }

        public Criteria orBankAccountIn(List<String> values) {
            orCriterion("bank_account in", values, "bankAccount");
            return (Criteria) this;
        }

        public Criteria orBankAccountNotIn(List<String> values) {
            orCriterion("bank_account not in", values, "bankAccount");
            return (Criteria) this;
        }

        public Criteria orBankAccountBetween(String value1, String value2) {
            orCriterion("bank_account between", value1, value2, "bankAccount");
            return (Criteria) this;
        }

        public Criteria orBankAccountNotBetween(String value1, String value2) {
            orCriterion("bank_account not between", value1, value2, "bankAccount");
            return (Criteria) this;
        }

        public Criteria andBankNameIsNull() {
            addCriterion("bank_name is null");
            return (Criteria) this;
        }

        public Criteria andBankNameIsNotNull() {
            addCriterion("bank_name is not null");
            return (Criteria) this;
        }

        public Criteria andBankNameEqualTo(String value) {
            addCriterion("bank_name =", value, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameNotEqualTo(String value) {
            addCriterion("bank_name <>", value, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameGreaterThan(String value) {
            addCriterion("bank_name >", value, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameGreaterThanOrEqualTo(String value) {
            addCriterion("bank_name >=", value, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameLessThan(String value) {
            addCriterion("bank_name <", value, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameLessThanOrEqualTo(String value) {
            addCriterion("bank_name <=", value, "bankName");
            return (Criteria) this;
        }

        public Criteria orBankNameIsNull() {
            orCriterion("bank_name is null");
            return (Criteria) this;
        }

        public Criteria orBankNameIsNotNull() {
            orCriterion("bank_name is not null");
            return (Criteria) this;
        }

        public Criteria orBankNameEqualTo(String value) {
            orCriterion("bank_name =", value, "bankName");
            return (Criteria) this;
        }

        public Criteria orBankNameNotEqualTo(String value) {
            orCriterion("bank_name <>", value, "bankName");
            return (Criteria) this;
        }

        public Criteria orBankNameGreaterThan(String value) {
            orCriterion("bank_name >", value, "bankName");
            return (Criteria) this;
        }

        public Criteria orBankNameGreaterThanOrEqualTo(String value) {
            orCriterion("bank_name >=", value, "bankName");
            return (Criteria) this;
        }

        public Criteria orBankNameLessThan(String value) {
            orCriterion("bank_name <", value, "bankName");
            return (Criteria) this;
        }

        public Criteria orBankNameLessThanOrEqualTo(String value) {
            orCriterion("bank_name <=", value, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameLike(String value) {
            addCriterion("bank_name like", value, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameNotLike(String value) {
            addCriterion("bank_name not like", value, "bankName");
            return (Criteria) this;
        }

        public Criteria orBankNameLike(String value) {
            orCriterion("bank_name like", value, "bankName");
            return (Criteria) this;
        }

        public Criteria orBankNameNotLike(String value) {
            orCriterion("bank_name not like", value, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameIn(List<String> values) {
            addCriterion("bank_name in", values, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameNotIn(List<String> values) {
            addCriterion("bank_name not in", values, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameBetween(String value1, String value2) {
            addCriterion("bank_name between", value1, value2, "bankName");
            return (Criteria) this;
        }

        public Criteria andBankNameNotBetween(String value1, String value2) {
            addCriterion("bank_name not between", value1, value2, "bankName");
            return (Criteria) this;
        }

        public Criteria orBankNameIn(List<String> values) {
            orCriterion("bank_name in", values, "bankName");
            return (Criteria) this;
        }

        public Criteria orBankNameNotIn(List<String> values) {
            orCriterion("bank_name not in", values, "bankName");
            return (Criteria) this;
        }

        public Criteria orBankNameBetween(String value1, String value2) {
            orCriterion("bank_name between", value1, value2, "bankName");
            return (Criteria) this;
        }

        public Criteria orBankNameNotBetween(String value1, String value2) {
            orCriterion("bank_name not between", value1, value2, "bankName");
            return (Criteria) this;
        }

        public Criteria andHandlingFeeIsNull() {
            addCriterion("handling_fee is null");
            return (Criteria) this;
        }

        public Criteria andHandlingFeeIsNotNull() {
            addCriterion("handling_fee is not null");
            return (Criteria) this;
        }

        public Criteria andHandlingFeeEqualTo(BigDecimal value) {
            addCriterion("handling_fee =", value, "handlingFee");
            return (Criteria) this;
        }

        public Criteria andHandlingFeeNotEqualTo(BigDecimal value) {
            addCriterion("handling_fee <>", value, "handlingFee");
            return (Criteria) this;
        }

        public Criteria andHandlingFeeGreaterThan(BigDecimal value) {
            addCriterion("handling_fee >", value, "handlingFee");
            return (Criteria) this;
        }

        public Criteria andHandlingFeeGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("handling_fee >=", value, "handlingFee");
            return (Criteria) this;
        }

        public Criteria andHandlingFeeLessThan(BigDecimal value) {
            addCriterion("handling_fee <", value, "handlingFee");
            return (Criteria) this;
        }

        public Criteria andHandlingFeeLessThanOrEqualTo(BigDecimal value) {
            addCriterion("handling_fee <=", value, "handlingFee");
            return (Criteria) this;
        }

        public Criteria orHandlingFeeIsNull() {
            orCriterion("handling_fee is null");
            return (Criteria) this;
        }

        public Criteria orHandlingFeeIsNotNull() {
            orCriterion("handling_fee is not null");
            return (Criteria) this;
        }

        public Criteria orHandlingFeeEqualTo(BigDecimal value) {
            orCriterion("handling_fee =", value, "handlingFee");
            return (Criteria) this;
        }

        public Criteria orHandlingFeeNotEqualTo(BigDecimal value) {
            orCriterion("handling_fee <>", value, "handlingFee");
            return (Criteria) this;
        }

        public Criteria orHandlingFeeGreaterThan(BigDecimal value) {
            orCriterion("handling_fee >", value, "handlingFee");
            return (Criteria) this;
        }

        public Criteria orHandlingFeeGreaterThanOrEqualTo(BigDecimal value) {
            orCriterion("handling_fee >=", value, "handlingFee");
            return (Criteria) this;
        }

        public Criteria orHandlingFeeLessThan(BigDecimal value) {
            orCriterion("handling_fee <", value, "handlingFee");
            return (Criteria) this;
        }

        public Criteria orHandlingFeeLessThanOrEqualTo(BigDecimal value) {
            orCriterion("handling_fee <=", value, "handlingFee");
            return (Criteria) this;
        }

        public Criteria andHandlingFeeIn(List<BigDecimal> values) {
            addCriterion("handling_fee in", values, "handlingFee");
            return (Criteria) this;
        }

        public Criteria andHandlingFeeNotIn(List<BigDecimal> values) {
            addCriterion("handling_fee not in", values, "handlingFee");
            return (Criteria) this;
        }

        public Criteria andHandlingFeeBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("handling_fee between", value1, value2, "handlingFee");
            return (Criteria) this;
        }

        public Criteria andHandlingFeeNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("handling_fee not between", value1, value2, "handlingFee");
            return (Criteria) this;
        }

        public Criteria orHandlingFeeIn(List<BigDecimal> values) {
            orCriterion("handling_fee in", values, "handlingFee");
            return (Criteria) this;
        }

        public Criteria orHandlingFeeNotIn(List<BigDecimal> values) {
            orCriterion("handling_fee not in", values, "handlingFee");
            return (Criteria) this;
        }

        public Criteria orHandlingFeeBetween(BigDecimal value1, BigDecimal value2) {
            orCriterion("handling_fee between", value1, value2, "handlingFee");
            return (Criteria) this;
        }

        public Criteria orHandlingFeeNotBetween(BigDecimal value1, BigDecimal value2) {
            orCriterion("handling_fee not between", value1, value2, "handlingFee");
            return (Criteria) this;
        }

        public Criteria andSubFeeIsNull() {
            addCriterion("sub_fee is null");
            return (Criteria) this;
        }

        public Criteria andSubFeeIsNotNull() {
            addCriterion("sub_fee is not null");
            return (Criteria) this;
        }

        public Criteria andSubFeeEqualTo(BigDecimal value) {
            addCriterion("sub_fee =", value, "subFee");
            return (Criteria) this;
        }

        public Criteria andSubFeeNotEqualTo(BigDecimal value) {
            addCriterion("sub_fee <>", value, "subFee");
            return (Criteria) this;
        }

        public Criteria andSubFeeGreaterThan(BigDecimal value) {
            addCriterion("sub_fee >", value, "subFee");
            return (Criteria) this;
        }

        public Criteria andSubFeeGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("sub_fee >=", value, "subFee");
            return (Criteria) this;
        }

        public Criteria andSubFeeLessThan(BigDecimal value) {
            addCriterion("sub_fee <", value, "subFee");
            return (Criteria) this;
        }

        public Criteria andSubFeeLessThanOrEqualTo(BigDecimal value) {
            addCriterion("sub_fee <=", value, "subFee");
            return (Criteria) this;
        }

        public Criteria orSubFeeIsNull() {
            orCriterion("sub_fee is null");
            return (Criteria) this;
        }

        public Criteria orSubFeeIsNotNull() {
            orCriterion("sub_fee is not null");
            return (Criteria) this;
        }

        public Criteria orSubFeeEqualTo(BigDecimal value) {
            orCriterion("sub_fee =", value, "subFee");
            return (Criteria) this;
        }

        public Criteria orSubFeeNotEqualTo(BigDecimal value) {
            orCriterion("sub_fee <>", value, "subFee");
            return (Criteria) this;
        }

        public Criteria orSubFeeGreaterThan(BigDecimal value) {
            orCriterion("sub_fee >", value, "subFee");
            return (Criteria) this;
        }

        public Criteria orSubFeeGreaterThanOrEqualTo(BigDecimal value) {
            orCriterion("sub_fee >=", value, "subFee");
            return (Criteria) this;
        }

        public Criteria orSubFeeLessThan(BigDecimal value) {
            orCriterion("sub_fee <", value, "subFee");
            return (Criteria) this;
        }

        public Criteria orSubFeeLessThanOrEqualTo(BigDecimal value) {
            orCriterion("sub_fee <=", value, "subFee");
            return (Criteria) this;
        }

        public Criteria andSubFeeIn(List<BigDecimal> values) {
            addCriterion("sub_fee in", values, "subFee");
            return (Criteria) this;
        }

        public Criteria andSubFeeNotIn(List<BigDecimal> values) {
            addCriterion("sub_fee not in", values, "subFee");
            return (Criteria) this;
        }

        public Criteria andSubFeeBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("sub_fee between", value1, value2, "subFee");
            return (Criteria) this;
        }

        public Criteria andSubFeeNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("sub_fee not between", value1, value2, "subFee");
            return (Criteria) this;
        }

        public Criteria orSubFeeIn(List<BigDecimal> values) {
            orCriterion("sub_fee in", values, "subFee");
            return (Criteria) this;
        }

        public Criteria orSubFeeNotIn(List<BigDecimal> values) {
            orCriterion("sub_fee not in", values, "subFee");
            return (Criteria) this;
        }

        public Criteria orSubFeeBetween(BigDecimal value1, BigDecimal value2) {
            orCriterion("sub_fee between", value1, value2, "subFee");
            return (Criteria) this;
        }

        public Criteria orSubFeeNotBetween(BigDecimal value1, BigDecimal value2) {
            orCriterion("sub_fee not between", value1, value2, "subFee");
            return (Criteria) this;
        }

        public Criteria andOrderAllAmountIsNull() {
            addCriterion("order_all_amount is null");
            return (Criteria) this;
        }

        public Criteria andOrderAllAmountIsNotNull() {
            addCriterion("order_all_amount is not null");
            return (Criteria) this;
        }

        public Criteria andOrderAllAmountEqualTo(BigDecimal value) {
            addCriterion("order_all_amount =", value, "orderAllAmount");
            return (Criteria) this;
        }

        public Criteria andOrderAllAmountNotEqualTo(BigDecimal value) {
            addCriterion("order_all_amount <>", value, "orderAllAmount");
            return (Criteria) this;
        }

        public Criteria andOrderAllAmountGreaterThan(BigDecimal value) {
            addCriterion("order_all_amount >", value, "orderAllAmount");
            return (Criteria) this;
        }

        public Criteria andOrderAllAmountGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("order_all_amount >=", value, "orderAllAmount");
            return (Criteria) this;
        }

        public Criteria andOrderAllAmountLessThan(BigDecimal value) {
            addCriterion("order_all_amount <", value, "orderAllAmount");
            return (Criteria) this;
        }

        public Criteria andOrderAllAmountLessThanOrEqualTo(BigDecimal value) {
            addCriterion("order_all_amount <=", value, "orderAllAmount");
            return (Criteria) this;
        }

        public Criteria orOrderAllAmountIsNull() {
            orCriterion("order_all_amount is null");
            return (Criteria) this;
        }

        public Criteria orOrderAllAmountIsNotNull() {
            orCriterion("order_all_amount is not null");
            return (Criteria) this;
        }

        public Criteria orOrderAllAmountEqualTo(BigDecimal value) {
            orCriterion("order_all_amount =", value, "orderAllAmount");
            return (Criteria) this;
        }

        public Criteria orOrderAllAmountNotEqualTo(BigDecimal value) {
            orCriterion("order_all_amount <>", value, "orderAllAmount");
            return (Criteria) this;
        }

        public Criteria orOrderAllAmountGreaterThan(BigDecimal value) {
            orCriterion("order_all_amount >", value, "orderAllAmount");
            return (Criteria) this;
        }

        public Criteria orOrderAllAmountGreaterThanOrEqualTo(BigDecimal value) {
            orCriterion("order_all_amount >=", value, "orderAllAmount");
            return (Criteria) this;
        }

        public Criteria orOrderAllAmountLessThan(BigDecimal value) {
            orCriterion("order_all_amount <", value, "orderAllAmount");
            return (Criteria) this;
        }

        public Criteria orOrderAllAmountLessThanOrEqualTo(BigDecimal value) {
            orCriterion("order_all_amount <=", value, "orderAllAmount");
            return (Criteria) this;
        }

        public Criteria andOrderAllAmountIn(List<BigDecimal> values) {
            addCriterion("order_all_amount in", values, "orderAllAmount");
            return (Criteria) this;
        }

        public Criteria andOrderAllAmountNotIn(List<BigDecimal> values) {
            addCriterion("order_all_amount not in", values, "orderAllAmount");
            return (Criteria) this;
        }

        public Criteria andOrderAllAmountBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("order_all_amount between", value1, value2, "orderAllAmount");
            return (Criteria) this;
        }

        public Criteria andOrderAllAmountNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("order_all_amount not between", value1, value2, "orderAllAmount");
            return (Criteria) this;
        }

        public Criteria orOrderAllAmountIn(List<BigDecimal> values) {
            orCriterion("order_all_amount in", values, "orderAllAmount");
            return (Criteria) this;
        }

        public Criteria orOrderAllAmountNotIn(List<BigDecimal> values) {
            orCriterion("order_all_amount not in", values, "orderAllAmount");
            return (Criteria) this;
        }

        public Criteria orOrderAllAmountBetween(BigDecimal value1, BigDecimal value2) {
            orCriterion("order_all_amount between", value1, value2, "orderAllAmount");
            return (Criteria) this;
        }

        public Criteria orOrderAllAmountNotBetween(BigDecimal value1, BigDecimal value2) {
            orCriterion("order_all_amount not between", value1, value2, "orderAllAmount");
            return (Criteria) this;
        }
    }

    /**
     * 该类对应数据库表 orders
     */
    public static class Criteria extends GeneratedCriteria {
        protected boolean andRelation;

        public boolean isAndRelation() {
            return andRelation;
        }

        protected Criteria() {
            super();
        }

        public void setAndRelation(boolean andRelation) {
            this.andRelation = andRelation;
        }
    }

    /**
     * 该类对应数据库表 orders
     */
    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean orValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isOrValue() {
            return orValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, boolean orValue) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
            this.orValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, boolean orValue) {
            this(condition, value, null);
            this.orValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, boolean orValue) {
            this(condition, value, secondValue, null);
            this.orValue = true;
        }
    }
}